Cross DB on a single query

[bradlymathews]

What you are looking for is the Query JSON With SQL Resource. Is basically uses SQL to query JSON and it can do JOINs.

Query JSON data with SQL statements | Retool Docs

Join data from two JSON arrays

Hi there, I am trying to join data from two JSON arrays into a single table and think I'm getting stuck on the nested responses. Could I kindly request a pointer I would like to match the 'address' in Table 2 with the 'validator' in Table 1 and where they match add 'name' to Table 1. Table 1 [image] I hope that makes sense? Thanks for your time Adding Table 2 to a follow up post due to restrictions

[Best Practice] JSON as SQL vs JS Query vs JS Transformer?

The scenario you suggest definitely calls for JSON SQL. If you can reason with the problem as linking multiple "tables" with a common ID then JSON SQL is the exact tool you need. If you have a basic understanding of SQL then it is far easier to build and understand than a bunch of JS array functions which I am sure you know can get pretty hairy real quick. I can't guarantee any performance metrics, but JSON SQL queries have always been pretty darn quick for me. I also use JSON SQL queries for …