You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If this issue only occurs in one browser, which browser is a problem?
No response
Describe the Bug
When using sql to select JSON fields, Astro returns escaped JSON even when using the SQL JSON() function. JSON fields are double escaped without the JSON() function.
What's the expected result?
JSON fields should be returned as parsed JSON for consistency with .select().
I probably don't have enough context to fix this myself, but I'm happy to submit the PR if someone can point at where the extra escaping is happening.
Astro Info
If this issue only occurs in one browser, which browser is a problem?
No response
Describe the Bug
When using
sql
to select JSON fields, Astro returns escaped JSON even when using the SQLJSON()
function. JSON fields are double escaped without theJSON()
function.What's the expected result?
JSON fields should be returned as parsed JSON for consistency with
.select()
.I probably don't have enough context to fix this myself, but I'm happy to submit the PR if someone can point at where the extra escaping is happening.
Link to Minimal Reproducible Example
https://github.com/jlengstorf/db-join-json-repro
Participation
The text was updated successfully, but these errors were encountered: