SQL Result: id | name 1 | John JSON: [{"id":1,"name":"John"}]
Yes, JOIN results can be converted to nested JSON structures.