Inlcude CLOB/JSON field content in queries

[Niklaus Aeschbacher]

Hi there, I'm not sure if I'm addressing a topic that already has been addressed in one or another way.

However, is it planned to include CLOB/JSON field content in regular SQL queries?
E.g. (phantasy query) "SELECT title, author FROM books WHERE tableOfContents.chapters.pageNr <= 10", whereas tableOfContents is a CLOB/JSON type field.
In other words, will it be possible to combine relational concept of h2 db with document db concept (e.g. MongoDb) at least in the sense of data queries.
My challenge in my h2 db is not only to store large JSON objects (which is already possible with current h2 version) but also to include the content of these objects in my queries.

Thanks
Nick