I appreciate your response and continue to be amazed by SQLite. No complaints, only confusion. As this is a parsing issue, would it make sense to amend the documentation to state that CTEs in subqueries and SELECT expressions work, even in triggers?
I appreciate your response and continue to be amazed by SQLite. No complaints, only confusion. As this is a parsing issue, would it make sense to amend the documentation to state that CTEs in subqueries and SELECT expressions work, even in triggers?