Hello, looking for a way to search the text of all SQL queries across collections.
In the app DB, the report_card table contains the question definitions. The dataset_query column contains the SQL query in a JSON object under native → query. That should be enough to write a query to search.
You can add the app DB to Metabase so you can explore Metabase’s app state with Metabase.
Be careful with exposing the app db though, it shows everything including user data, so restrict access to people you trust.