Unfortunately Convex does not directly
Unfortunately, Convex does not directly provide a SQL interface, so it's not possible to use it in this way. There is one solution now, and one we may ship down the road a bit: (1) today, you can use Airbyte or now Fivetran to create a streaming replica of your Convex project in a SQL-oriented system like snowflake, postgresql, bigtable, clickhouse, whatever. This tool can be hooked up to whatever 3rd party things (CMS, BI, etc) want a SQL interface; (2) some point down the road we are considering exposing a sql interface that will be a read-only slightly stale replica, possibly built on duckdb. That would make this possible without any set up, as long as you don't require the ability to mutate data and don't need the data to be fully consistent with transactions
