search

roddyyaga / ppx_rapper

Syntax extension for writing SQL in OCaml
Other
139 stars 18 forks source link

multiple lists in WHERE IN #39

Open mudrz opened 10 months ago

mudrz commented 10 months ago

Currently doing a WHERE with multiple lists is not supported - it fails with error:

The query contains multiple lists. Multiple lists are not supported

Just curious - what is the limitation that you can't use multiple lists? Are there any alternatives ? Trying to run something similar to:

    WHERE
    some_id IN (%list{%int{my_ids}})
    OR another_id IN (%list{%int{other_ids}})

Is a manually generated query the only way?