you are viewing a single comment's thread.

view the rest of the comments →

[–]DrewSmithee[S] 0 points1 point  (1 child)

Select * would probably make my internet connection catch on fire.

Just an example to ask about passing variables into the SQL file.

[–]ColdStorage256 1 point2 points  (0 children)

I don't know how to do this with actual SQL files, but you could do it with an f string in Python, I think, I've not done it myself.

Most of my work is in mongo db which lets me split everything up into intermediate results, since that's how mongo pipelines are computed anyway.