Version

1.18.0

What happened?

Sqlc could not support table alias, the sql example is in below.

The error message is "table alias "t1" does not exist"

Relevant log output

No response

Database schema

CREATE TABLE authors (
          id   BIGINT PRIMARY KEY AUTO_INCREMENT,
          name text      NOT NULL,
          bio  text
);

SQL queries

/* name: ListAuthors2 :many */
select * from (SELECT * FROM authors) as t1 where t1.id > ?;

Configuration

No response

Playground URL

No response

What operating system are you using?

No response

What database engines are you using?

No response

What type of code are you generating?

No response