Datasette is a tool for exploring and publishing data. Uses sqlite for storing data and is written in python and exposes the db over a web interface. support adhoc querying (made posible by mounting the database file in Readonly mode, so destructive operations are possible).
The author -- Simon Willison has substack newsletter for the project.
How he uses datasette -- "What is the killer app for datasette"; Oct 2022.
datasette.io, an official project website for Datasette -- a blog post detailing how datasette is used to publish a website, in this case the website of the project itself. which uses the The Baked Data architectural pattern.