Hi,
What would "support" exactly mean for a JSON type? Since JSON is a way of serialising data into a string, wouldn't all JSON values going into and out of the database just look like strings to the driver?
For Postgres's array types, some support for serialising and unserialising would definitely be useful, though, because the format is rather complex, particularly if you have multidimensional and sparse arrays. Obviously, users now have the workaround of transferring as JSON, but I know my last company had a pair of utility functions to attempt this in userland, which were known to be buggy in certain edge cases.
Regards,
JSON should be automatically converted to proper type(s).
$data = ['name' => 'John'];
$sth = $dbh->prepare('INSERT INTO table (json_column) values (:data)');
$sth->bindParam(':data', $data, PDO::PARAM_JSON); // new parameter
SELECT json_column FROM table;
$stmt->fetch(PDO::FETCH_ASSOC) should return
array(
[json_column] => array('name' => 'John')
)
.