Sql query with json subquery returns null but works when directly querying database
I have a sql query that returns a list of objects as json similar to this:
I have a sql query that returns a list of objects as json similar to this: