Querying Complex JSON Objects With SQL

Written by jacobbcohen | Published 2021/05/20
Tech Story Tags: sql | json | array | arrays | coding | programming | querying | database

TLDR HarperDB’s ARRAY() function is an aggregate function, similar to COUNT, SUM, AVG and COUNT. The difference is that while standard aggregate functions will return computation results. HarperDB can perform these transformations out-of-the-box with a single query. This query effectively performs the job of an ORM without the need for bloated software. Use Cases for the use of the function include a simple example of people with addresses and phone numbers. You can also view the data below to see the data from a single table.via the TL;DR App

no story

Written by jacobbcohen | STEM Advocate | Car Guy | SQL Stan | Director of Engineering at HarperDB | Robotics Judge Advisor and Referee
Published by HackerNoon on 2021/05/20