[reassembled]

I just want to add a plug for the very awesome DBeaver, a cross platform native GUI front end which supports pretty much every major database format.

I use it every day on Windows and Linux for viewing and editing SQLite and PSQL databases. I've also used it to dump and restore tables in a pinch. It supports dumping and importing tables in a multitude of formats, including JSON and plain SQL statements.

[bbkane]

The two open source SQL IDEs I really like are https://www.beekeeperstudio.io/ and https://dbgate.org/ . Both very nice for my somewhat simple querying needs

[mritchie712]

I also like tableplus. small team charging a reasonable fee for a great product.