scp is the way I implemented querying a remote SQLite database under the hood in my data ide. Now that I think of it though I should probably add some clarification to docs or the UI that you're querying a local copy of the database and that your edits won't affect the original.
I just scp the whole database to my local machine and use "db Browser for SQLite" (a mac app) :)
Would love to hear if there are other server-based db browsers for SQLite, though.