is there no IN for XTDB2? I'm writing a batched Pathom resolver and I'm a bit wary of writing (or (= my/id #uuid "....") ...) for perhaps 200 IDs at a time.
Thanks for sharing your solution, I think that's the right approach here. XTQL definitely isn't deprecated - the tutorial is just a little out of date (😅) - but evolving it is not our focus right now compared with shipping a high quality SQL experience. That said, feedback like this is welcome 🙏
I would expect IN to work in SQL for XTDB2...?
yep I am using it in SQL
In SQL for sure. I'm using XTQL and it's not in the docs. But it's also not "standard lib" exactly. I wonder if contains in clojure style will work.
Why not use SQL for queries? HoneySQL supports the temporal stuff for XTDB and next.jdbc is explicitly tested against XTDB in CI.
deps count and ease. XTQL is pleasant to work with and nothing else in this project has anything to do with SQL. but perhaps I should switch gears.
SQL is the primary API Juxt are supporting at this point.
that's a fair point.
looking at the (deprecated?) Learn XTQL Today, there are rel inline relations; perhaps unifying a relation containing the input values is the way to do it. that's how it would work in Datalog, I suppose.
I tried it and that does work, FWIW.