How to turn SQL into JSON?

Question

SQL

So it goes.
There is this kind of SQL:

How do I translate it into this kind of JSON:

{
"Audi" : ["A6", "Q7", "R8"],
"Daewoo" : ["Matiz", "Nexia", "Gentra"]
}

Answer 1

Is it possible to get a JSON response from SQL with...