Feature: Add a sqllogic test

[carlopi]

I see that currently there are no tests available, and in the future we might want for community extensions to rely more on them.

Could you consider adding an sqllogic test? to the test/sql directory?

[freddie-freeloader]

Hey @carlopi,

We had some Python scripts for checking the correctness of the parse results -- but I could definitely add tests that work with the DuckDB scripts.

Are there test files using sqllogictest that you know of? These could be helpful, since I could use them as a starting point. ☺️
Edit: I found the page in the DuckDB docs. 👍
For reference: https://duckdb.org/docs/dev/sqllogictest/intro.html

[carlopi]

Just to state, this is very much a suggestion, but extension is great as is obviously.