have you already heard of a tool called Datasette? I discovered it yesterday and find it really handy.
The author presenting it (this is the best):
So basically you can just throw an SQLite database at it, and it creates a complete web-API for that dataset including facets, filtering, different output formats for filtered subsets, showing things on a map (if columns are called longitude and latitude), etc.
Does any of you have experience with it? I am considering to use it for out Open Power System Data project https://open-power-system-data.org/ where all our frictionless datapackage based Data Packages are also shipped with an SQLite database - so it would be a relatively easy set for us.