Sqlx: Support JSON for Postgres

[abonander]

Support taking and returning serde_json::Value (maybe others as well?) in queries.

I think this would be a Postgres-only feature, right?

[sazzer]

Postgres has first class JSON support, but technically you can store JSON in text blobs in mysql as well - Indeed we actually do exactly that at my work.

[abonander]

We could serialize JSON to text for MySQL but the query!() macro couldn't possibly know to read out a varchar field as JSON.

We could make it work with query_as!() but it'd be difficult to discover serendipitously; we'd need an example showing it.

[dervus]

I'm not an expert in MySQL, but why this isn't suiting? https://dev.mysql.com/doc/refman/8.0/en/json.html

[sazzer]

It depends on the MySQL version. We're still using 5.6. because of some other tooling requirements, so it's not available there. If you're on a new enough version then that would make it a lot easier though :)

[mehcode]

JSON for Postgres is in master. Thanks @oeb25! I'll spin out another issue for MySQL.