Sometimes difficulty using own CTEs in expressions

[akdor1154]

Tested with snowflake, seems to work in some cases and fail in others.

q1 = Q(...)
q2 = Q(lambda: f"""
with cte as (
  select blah from foo join {q1}
)
select blah
""")

syntax error line * at position 0 unexpected 'with'

[akdor1154]

this hack is useful, considering including it:

# TODO add to csql
def withhack(q):
	import re
	pat = re.compile(r'^[\s\n]*with\s', re.DOTALL)
	return pat.sub(', ', q)

print(withhack('\n with hi as '))