Is there a way to make a where subclause behave like an outer join? As in, don't eliminate the entity from the result if a certain expression doesn't match? I'm trying to pull multiple entities out of the DB, with some of them being optional.

1.24.3 has just been released! 🚀 Release notes here: https://github.com/xtdb/xtdb/releases/tag/1.24.3 Thanks to all who contributed, raised issues or assisted in this release 🙏.