Identity PoC
Add
Search
Query
Cases
Judge
As of
Apply
Query
Ask in plain words
Write the SQL
The model writes the SQL; it is shown below and runs only when you press Run.
Legal entities sharing one website
What keying on the website would fuse: the entities that state the same registrable domain.
The SQL
(always shown and editable; runs on a read-only connection with a 5 second limit and at most 500 rows)
SELECT k.domain, u.urn, s.name FROM v_url_key k CROSS JOIN LATERAL unnest(k.entity_urns) AS u (urn) JOIN v_subject s ON s.urn = u.urn WHERE k.fused ORDER BY k.domain, s.name
Run