content icon indicating copy to clipboard operation
content copied to clipboard

Allow queries to use SQLite functions

Open so1ve opened this issue 1 month ago • 0 comments

Is your feature request related to a problem? Please describe

Currently we cannot use where to query nested fields e.g. where("foo.bar", "=", "test").

Describe the solution you'd like

After some research I found that I needed to use json_extract function to do this, but the first parameter of where seems to be forced to be wrapped in quotes. Enabling such usage would be much more convenient.

Describe alternatives you've considered

Additional context

https://github.com/nuxt/content/issues/2960#issuecomment-2586545453 says not yet supported in Content query builder.

so1ve avatar Nov 11 '25 20:11 so1ve