Fairly recent and related:

https://news.ycombinator.com/item?id=40909076 411 points | 84 days ago | 68 comments

Not mine but someone showed me this :

https://azimutt.app/

I'm working on something related but for the web: https://www.sqltab.com/

It's an alpha version and barely works at this point but at the very least you can use it to browse SQLite tables without installing anything on your computer.

It uses the WASM build of SQLite with OPFS for persistence. The main focus of this will be to manipulate JSON stored in an SQLite table. I need this for one of my existing workflows. In particular, I want the ability to flatten a JSON tree into tabular format: https://youtu.be/z0QvxyMybKA

Great tool, just found it a few months ago. I am a pretty hardcore CLI/TUI user so I am generally reluctant to reach for GUIs but this gets the job done and comes in quite handy when the sqlite3 cli just doesn't cut it.