> On Aug 19, 2022, at 3:57 PM, Sean Broeder <[email protected]> wrote: > > Thanks for the clarification > >> On Aug 19, 2022, at 3:23 PM, Julian Hyde <[email protected] >> <mailto:[email protected]>> wrote: >> >> Column aliases are only available in the ORDER BY clause. In some >> dialect-compliance settings, they are also available in the GROUP BY and >> HAVING clauses. But not in the WHERE clause. > Hi Julian, It looks like some databases do support column aliasing in where clauses, for example, Terradata documentation indicates it does. https://docs.teradata.com/r/Teradata-Database-SQL-Fundamentals/June-2017/Basic-SQL-Syntax/Referencing-Object-Names-in-a-Request/Using-a-Column-Alias
I am interested in this feature and would contribute an enhancement to Calcite if it’s possible. Do you happen to know if the current lack of support is due to technical difficulties/limitations or it simply hasn’t been implemented yet? Also, if the latter, do you have a pointer to where I might start looking? Thanks, Sen
