Use a view. It is very challenging to say

SELECT 'f' as FOO

is equal to

SELECT 'a' as FOO

.

Thanks @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?

Okay, in this case just use a view with different where clauses to get the same type (the view).

Shameless plug: https://leandrofavarin.com/sqldelight-powerful-codegen