At first, this may not appear to be an appropriate answer to your question, but data table form permissions set to ‘can search, edit, and delete’, along with ‘write back’ bindings in a repeating panel give you quick and malleable create, edit, delete, and query access to any/every column in your tables (see the search and sort example above - the Anvil ORM search criteria can be edited as needed to satisfy your SQL-like query requirements). The basic examples above just give you a standardized UI interface to Create Read Update and Delete tables, and apply filer/sort criteria to your table views.
NOTE: form permissions are per app, as opposed to per data table, so you can create a single quick admin app like the examples above, with fast access to a shared data table, without exposing form permissions in your client app(s).