Difference between query modes
Heyo everyone ! 👋
Is there anyway I can get same result than result1 query using result2 syntax with db.select() ?
Or should I keep using db.query if I want to retrieve notifications with group inside of it ?
1 Reply
You could do it, but you'll need to use json array aggregation sql functions
You can take a look at the query that
result1
produces to see what functions are used
fair warning, it will be complicated if you're not familiar with sql