============== TEMPLATE ==============
✅ Describe your idea or issue
I'm trying to convert a script from using the sqlite3 library to sqllex, and WHERE x in (...) is the one feature I seem to be missing.
e.g. there doesn't seem to be any way to do this using sqllex:
SELECT * FROM COMPANY WHERE AGE IN ( 25, 27 );
✅ Additional context
I could string together OR statements, but that's not ideal.
============== TEMPLATE ==============
✅ Describe your idea or issue
I'm trying to convert a script from using the sqlite3 library to sqllex, and
WHERE x in (...)is the one feature I seem to be missing.e.g. there doesn't seem to be any way to do this using sqllex:
SELECT * FROM COMPANY WHERE AGE IN ( 25, 27 );✅ Additional context
I could string together OR statements, but that's not ideal.