We use sqllogictest-rs to test the SQL queries.
To run all tests, use the following command:
sqllogictest './tests/**/*.slt'
Each time you modify the source code, you can run the following command to clean up the test data and reload the extension:
psql -f ./tests/init.sql