content
content copied to clipboard
Allow queries to use SQLite functions
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.