mechatroner / RBQL

🦜RBQL - Rainbow Query Language: SQL-like query engine for (not only) CSV file processing. Supports SQL queries with Python and JavaScript expressions.
https://rbql.org
MIT License
276 stars 13 forks source link

Add support for ordering by aliased column #41

Open chtenb opened 1 year ago

chtenb commented 1 year ago

In the following query

select a.col1, a.col2, string_overlap(a.col1, a.col2) as overlap order by string_overlap(a.col1, a.col2) desc

I would like to say order by overlap desc instead of repeating the function call. However, that does not seem to be supported. string_overlap is a custom python function here.