Is there a way to pass a schema of a table separately? For example, I have plenty of tables with the same name but different schema. Initially, my template was something like this:
select from :i:schema1.table
join :i:schema2.table
join :i:schema3.table
I thought that it would be enough to pass a map like {:schema1 "foo" :schema2 "bar" :schema3 "baz"} but HugSQL considers :schema1.table as a standalone parameter. is it possible to let HouSQL think that :schema1 is the only part of a parameter?In other words, is there any syntax to achieve this:
-- :name some-query
select from {:i:prefix}_some_schema.table
(some-query db {:prefix "prod"}) =>
"select from prod_some_schema.table"