3 ms·
You are not using any variables or anything from bash in that query. Wouldn't it make more sense to extract it to a .sql file and just run that, rather than you
by remram 5y ago
You are not using any variables or anything from bash in that query. Wouldn't it make more sense to extract it to a .sql file and just run that, rather than your (rather long) heredoc?
- chmaynard 5y agoAgreed. I like having the query in situ during development because it simplifies editing. But there are disadvantages that you and others have identified.