Running SQL Queries in Datasette in Python.

Datasette is Read Only SQL

SQL is a query langauge that's been going strong since the 70ies and you can also expect support inside of datasette. You don't need to worry about giving SQL access to your end-users though because the sqlite database is configured in read-only-mode.

Running SQL in Datasette

We've gotten a deployment of datasette live that you can explore here. You can run queries but also explore the interface from there.