JSON fields are always escaped when using sql

[jlengstorf]

Astro Info

Astro                    v4.11.5
Node                     v22.1.0
System                   macOS (arm64)
Package Manager          npm
Output                   static
Adapter                  none
Integrations             astro:db
                         @astrojs/db/file-url

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.

Link to Minimal Reproducible Example

https://github.com/jlengstorf/db-join-json-repro

Participation

• I am willing to submit a pull request for this issue.