justinclift
commented
1 year ago @mshiner Apologies, we somehow completely missed several issues filed in this repo.
The concept you're suggesting here would probably not be to tooo hard to implement.
Maybe something like having an optional parameter for the query endpoint to specify the return format, plus figuring out what kind of html structure would be suitable.
That being said, there are a bunch of other higher priority things to get some first (showing user usage info, implement some kind of monthly subscription thing, etc), so it'll be a while until we look at the idea properly.
The cli for sqlite has an output .mode of HTML to allow returning an HTML representation of a select statement.
This maybe a mad idea but I think it'd be cool if the /query endpoint of the dbhub.io api could do the same thing with the option to turn headers on or off.
The reasoning is that this would be a good fit when using HTMX which expects an endpoint to return an html fragment rather than json.