Add support for CTE

[MarinPostma]

CTE are blacklisted. They can also perform write, so enabling them require carefully categorizing them in query_analysis

[psarna]

what's CTE? :innocent:

[MarinPostma]

Common Table Expression: https://www.sqlite.org/lang_with.html