René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Bug When Using Table Aliases: `table alias \"all_users\" does not exist`","articleBody":"### Version\n\n1.25.0\n\n### What happened?\n\nSqlc encounters issues when attempting to recognize table aliases specified within the WHERE clause, particularly when filtering selections using the syntax alias_table.field = 'something'.\r\n\r\nI've provided a simple example to replicate the issue\n\n### Relevant log output\n\n```shell\nsqlc generate failed.\r\n\r\n# package \r\nquery.sql:8:39: table alias \"all_users\" does not exist\n```\n\n\n### Database schema\n\n```sql\n-- Create users table\r\nCREATE TABLE users (\r\n    id SERIAL PRIMARY KEY,\r\n    email VARCHAR(100) NOT NULL,\r\n    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\r\n);\r\n\r\n-- Create posts table\r\nCREATE TABLE admins (\r\n    id SERIAL PRIMARY KEY,\r\n    email VARCHAR(100) NOT NULL,\r\n    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: GetAllUsers :many\r\nWITH all_users AS (\r\n    SELECT id, email FROM users\r\n    UNION\r\n    SELECT id, email FROM admins\r\n)\r\nSELECT id, email FROM all_users where all_users.email=$1;\n```\n\n\n### Configuration\n\n```yaml\nversion: \"2\"\r\nsql:\r\n- schema: \"./db/migrations/\"\r\n  queries: \"./pkg/postgres/queries/\"\r\n  engine: \"postgresql\"\r\n  gen:\r\n    go: \r\n      package: \"postgres\"\r\n      out: \"./pkg/postgres/sqlc\"\r\n      emit_json_tags: true\r\n      emit_prepared_queries: false\r\n      emit_interface: true\r\n      emit_exact_table_names: false\r\n      emit_empty_slices: true\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/388ae1f5e3a9ab6c0185bdfce9ead7acbbb6ece3d6a52d828cd40184b109caf3\n\n### What operating system are you using?\n\nLinux\n\n### What database engines are you using?\n\nPostgreSQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/AvicennaJr","@type":"Person","name":"AvicennaJr"},"datePublished":"2024-02-01T12:52:22.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":10},"url":"https://github.com/3169/sqlc/issues/3169"}