sqllex icon indicating copy to clipboard operation
sqllex copied to clipboard

FEATURE | WHERE x IN (...) support?

Open greay opened this issue 1 year ago • 0 comments

============== 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.

greay avatar Aug 06 '24 00:08 greay