Use a view. It is very challenging to say `SELECT ...
# squarelibrariesh
hfhbd
02/15/2023, 8:48 AMUse a view. It is very challenging to say
SELECT 'f' as FOOSELECT 'a' as FOOh
humblehacker
02/15/2023, 3:01 PMThanks @hfhbd. Can you elaborate? Your example doesn't seem to relate to my question. I was referring to queries that select the same fields on the same table, but with different where clauses. How can a view help this situation?
humblehacker
02/15/2023, 3:03 PMI realized I left that crucial bit about the same fields out of my original question. I've updated it.
h
hfhbd
02/15/2023, 5:16 PMOkay, in this case just use a view with different where clauses to get the same type (the view).
l
leandro
02/17/2023, 10:41 PMShameless plug: https://leandrofavarin.com/sqldelight-powerful-codegen
4 Views