3 ms·
I have not tried it out, but the := notation and bash expansion example looks very compelling. One could in fact template SQL scripts expecting tables a,b,c as
by loa_in_ 7y ago
I have not tried it out, but the := notation and bash expansion example looks very compelling.
One could in fact template SQL scripts expecting tables a,b,c as input and just substitute inputs for premade operations.
- jolmg 7y agoThat's pretty good. Seems like a good reason to add an -f alternative to -q to provide an sql file. In fact, now that I remember, it has happened that I'll be provided a CSV, so I write this big query. Then, from analyzing the results, they'll tell me they made a mistake with the CSV they gave me and provide me with a corrected one. They'll use a different name to avoid confusion in not knowing which is the bad one and which is the corrected one, and I just change the file in the assignment and rerun the same SQL.