🪲 Column Not found when Relation invalid

[joocer]

Thank you for taking the time to report a problem with Opteryx.

To help us to respond to your request we ask that you try to provide the below detail about the bug.

Describe the bug A clear and specific description of what the bug is. What the error, incorrect or unexpected behaviour was. Found this because of a typo, I used p.name, when it should have been P.name, was confusing the error drew my attention to the name column which does exist, I got the table name wrong.

Expected behaviour A clear and concise description of what you expected to happen. The error should be about the p relation not the name column.

Sample Code/Statement If you can, please submit the SQL statement or Python code snippet, or a representative example using the sample datasets.

"SELECT * FROM $planets AS P LEFT JOIN $satellites AS S USING(id) WHERE p.name LIKE '%a%';