Does it support subquery and table alias?

[sekarpdkt]

Does it support sub query and table alias?

select f.col1 A, f.col2 B, s.colx C
from foo f, ( select colx from bar where colx=123) s
where f.colx=s.colx

[janosimas]

Alias should not be a problem, since the from method only stores a string,
I imagine this should work:

...
  .from("foo f")
...

About sub queries, this is one of the reasons I'm still thinking about using this lib.

[tomlankhorst]

If aliases work because the from is stored as a string, then I feel like subqueries should work too.

.from("("+subquery.str()+") sub")