π in v2, is there a way to get a list of tables by sending a SQL query to the /query resource?
Hey @aviflax yep π try this:
curl --request POST \
--url '' \
--header 'Content-Type: application/json' \
--data '{"sql": "SELECT table_name\nFROM information_schema.tables", "queryOpts": {"txTimeout": "PT1S", "keyFn": "SNAKE_CASE_STRING"}}' at some point in the future you may want to add a WHERE table_type = 'BASE TABLE'; clause to that query unless you want to see VIEWS or other forms of tables in that list