How to Count and Group JSON Data in PostgreSQL Using FILTER
Today I needed a query that could take some nested JSON data, a column ID, and then create a single row for each of these distinct column ID’s to show some summary numbers of different nested JSON values. I’ve horribly explained that, and so you can imagine just how much fun I had writing the … Read more