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.