I normally use MySQL / MariaDB, but I’m looking at working with SQLite for some little personal projects.
I’m a huge fan of phpMyAdmin, and I know there’s a version that handles SQLite - but I don’t want to mess around with installing a web server on my Mac just to run that.
Can anybody recommend a good, native Mac app that allows me to just open a database, view / edit tables a little more visually, and do SQL queries?
My go to tool for all SQL work is DbVisualizer there is a free version, but the pro version is worth the $197, I have used it for the best part of 15+ years. It is Java based and works on Mac, Linux & Windows. I have used it with SQLite, MySql, Postgresql, SQL Server, DB2 and Oracle. Support has always been excellent. It has ssh capability and command line options.
Base
I don’t use it often but it’s been helpful for dissecting MaxQDA databases.
That looks lightweight and pretty easy to use. 
Thanks!
I use SQL Pro Studio, I have it through SetApp and find it a solid app. I’m sure there are plenty of other contenders though!
I like Base, too, although my use is pretty light. It comes with Setapp.
Personally I go really old school. I do 99% of my SQLite stuff in an old rev of Firefox (56.0.2 ) with the SQLite Manager plug in. Doesn’t work in any modern version of Firefox for security reasons but as long as it’s isolated it’s a quick simple tool.
If I can’t do it in that I use SQLite Manager from SQLabs. Works well enough for me. I have an older free version but I see they are chanign things and may be offering a package that has more features.