Hello,
First of all, thank you very much for this very nice package. Very readable code that i would very much like to use.
In my project, I generate queries to use with the encode/databases package for async access to several sql backends.
I tried to create an engine that would generate databases like query, that use a :query_arg style notation.
It seems that parameters are not aware of their own names, so I'm running into problems. Am I missing something ?

https://www.encode.io/databases/database_queries/ for references

Thank you very much.

Is there any way to select from a query instead of a table?

Say I was given a complicated query with lots of table joins and conditions, but I wanted to select from it similar to a common table expression (CTE).

For example,
Assuming the "query" returns a table like data set and I would filter that data set as normal in the
query = "select field1, field2, ... from table1 inner join table2 inner join table3 ..."

Given the above query, I would like to select from it as follows, using the ".from()" from sql-smith, resulting in the following query output:

SELECT * FROM (query) AS api_query WHERE field1 = 2112

Is this possible?