Is it possible to return nested JSON values on queries. For example lets say we have two tables named category and post which are connected together using a FOREIGN KEY. we can use a JOIN in a query and have them in flat rows. but is there a solution to have like an array of posts in each category row to have the posts of that category or vice versa, like having a JSON containing posts. with a nested JSON containing category information?
Thanks in advance,