Aliases unavailable in `WHERE` clauses.

Question

Aliases unavailable in `WHERE` clauses.

Closed this issue a year ago · 1 comments

Example: SELECT 1 AS foo WHERE foo = 1.

Answer 1 · 2024-01-18T12:04:59.000Z

After discussions offline, let's not support this. MySQL does not allow it, and while SQLite supports some flavor of this (namely when the alias refers to a non-aggregate expression), it would take significant work to support it in SKDB with limited benefits.