Solutionunvalidated
If you want to use jOOQ API for these two things, use the above functions. — `->>` which translates to `jsonGetAttributeAsText`. Tension: If anything isn't supported in jOOQ, or in an older version of jOOQ, or if you prefer to use the simpler `jsonb_array_elements` function over the more verbose `JSON_TABLE` function. Outcome: just use plain SQL templates, as always.
cc5d4f4e-1c36-4d20-b97b-8c70a50b59d1
If you want to use jOOQ API for these two things, use the above functions. — ->> which translates to jsonGetAttributeAsText. Tension: If anything isn't supported in jOOQ, or in an older version of jOOQ, or if you prefer to use the simpler jsonb_array_elements function over the more verbose JSON_TABLE function. Outcome: just use plain SQL templates, as always.