https://kotlinlang.org logo
#squarelibraries
Title
# squarelibraries
r

Richard Glen

11/25/2023, 4:38 AM
[SQLDelight - Errors when selecting from VIEW] Whenever I run gradle generateMainWhiteCloakKpiDatabaseInterface, I encounter issue:
Unexpected column alias parent {}: []
image.png
Ohh. I found a workaround. I don’t think the syntax:
CREATE VIEW <viewname> AS <CTE SYNTAX>
is supported? This worked:
CREATE VIEW <viewname> AS (SELECT * FROM (<CTE SYNTAX>))
It kinda weirded be out because both syntax executes just fine in the SQLDelight Idea plugin
2 Views