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
281 stars 13 forks source link

Handling column names directly: Part 2 #27

Open mechatroner opened 3 years ago

mechatroner commented 3 years ago

RBQL can now handle a.good_alphanumeric_column_name and a["arbitrary column name!"] notation (see #6 ). But it would be great to go further and support direct column variables like name, surname, price etc without a and b prefixes. It is not clear yet if it is possible at all to handle raw column names reliably and transparently. The most obvious problem is a potential conflict between column names and Python/JS identifiers, e.g. columns named class, if, sys, function, etc.