[odb-users] WITH Queries in Views

[Brian Coggins]

Hello Boris and friends,

Back in Jan 2023, I was running into trouble trying to create a view using a WITH … query, and Boris helpfully explained about the ODB compiler:

Yes, it tries to guess whether it's a complete query or the WHERE
clause by checking if the query starts with one of the known keywords
(like SELECT). I have a TODO item to recognize some additional database-
specific keywords (like WITH).

I’ve run into this limitation again, this time in the context of a WITH RECURSIVE … query that I don’t think can be accomplished any other way.  I upgraded to ODB 2.5.0-b.27 but it seems the issue is still there.

Any chance we might be able to get a patch to loosen up these restrictions?

Thanks,
Brian