[SQLDelight - Errors when selecting from VIEW] Whe...

# squarelibraries

[Richard Glen]

[SQLDelight - Errors when selecting from VIEW]
Whenever I run gradle generateMainWhiteCloakKpiDatabaseInterface, I encounter issue:

Unexpected column alias parent {}: []

[Richard Glen]

image.png

[Richard Glen]

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>))

[Richard Glen]

It kinda weirded be out because both syntax executes just fine in the SQLDelight Idea plugin