Hi all.
After read <https://tapoueh.org/blog/2017/06/how-to-write-sql/> i
wanted to try to do the same with my sqlite queries.
Sadly, the sqlite command line shell don't support variables.
For that i want to suggest to add the support of variables
in the command line shell.
For start thinking about it, i attached a proof of concept of the
feature. The license for the POC is the same as sqlite: public domain.
Comments about the POC:
1. I use another database (in memory) to persist variables between
changes of databases (.open command).
2. A missing part is add a command line argument similar to `-var
name value` for assign variables from the command line.
Greetings,
JMPC.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
