Repository navigation
Sqlc could not support table alias (error: table alias "t1" does not exist) #2400
Description
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
Reacted by jessepinkman9900, krisztian-pno and Krisztián Tóth
Activity
feat(compiler): Support subqueries in the FROM clause
feat(compiler): Support subqueries in the FROM clause (#3227)
feat(compiler): Support subqueries in the FROM clause
feat(compiler): Support subqueries in the FROM clause (second coming) (…
feat(compiler): Support subqueries in the FROM clause
feat(compiler): Support subqueries in the FROM clause
feat(compiler): Support subqueries in the FROM clause
feat(compiler): Support subqueries in the FROM clause
Dmdv commentedon May 15, 2024
Hi everyone
This error persist since 2022.
Can someone ping the pull request #3220
How one can possibly work without CTE or joins?
Is SQLC only for primitive cases?
Please, pay attention to issues:
#2400
#3169
#1385
Though the solution of @smantic works well:
#1385 (comment)
feat(compiler): Support subqueries in the FROM clause (sqlc-dev#3227)
feat(compiler): Support subqueries in the FROM clause (second coming) (…
feat(compiler): Support subqueries in the FROM clause (sqlc-dev#3227)
feat(compiler): Support subqueries in the FROM clause (second coming) (…
dev-kpyc commentedon Nov 17, 2025
@kyleconroy any plans to fix this issue?
I see this previous PR to address this was ultimately reverted: #3299