Stacksmith
Stacksmith copied to clipboard
SQLite database commands
Queries should ideally be specified as something between LINQ and the search command's syntax. Make it so users don't have to escape query values etc., not unlike prepared statements in SQL. Maybe even throw in SQL support while we're at it.
This seems like a starter bug at first, but to do this right, we don't want to expose the user to SQL syntax. So there'd need to be parser support for parsing an expression and then generating some sort of format string from it (same thing we'd need for the "sort" command). Alternately, one could fake it like in the "download" command and generate a function with a name impossible for the user to type based on the expression, and then call that function to generate the query string. Might involve some CNodeTransformation subclasses to wrap up the query parameters without the user having to do it manually.