App Builder and sql query

Question

I implement autocomplete and store the data for it in the state.

But there is no way to send direct sql queries to the state.

I see that adobe-lib-state is a wrapper around Azure DB Cosmos.

As I understand it, it looks like you can write sql queries directly into the cosmos database.

Question:

The ability to write SQL queries for '@adobe/aio-lib-state' is not implemented because they won't work?

Or are they not implemented, but if you write directly (state?._cosmos?.container?.items) queries, will it work?

Regards,

Eugene

purplecabbage · Answer

Cosmos is an implementation detail, and will definitely change in the future.  Any state-lib usage outside the provided api will break at some point.

Sign up