In this query:
SELECT id FROM tbl WHERE id IN (1,2,3)
Clearly, using the _xpack/sql/translate endpoint this will error in that the IN clause is not supported.
What would be the equivalent SQL statement for a query above? I've been searching, and there's nothing in the ES documentation.
Any pointers would be much appreciated.