search

DataJunction / dj

A metrics platform.
http://datajunction.io
MIT License
29 stars 13 forks source link

Support selecting wildcards in node queries #993

Open shangyian opened 1 month ago

shangyian commented 1 month ago

Summary

This PR adds support for writing SELECT * in node queries.

During the Wildcard compile stage, it expands out SELECT * to all available columns on the table references. This may include DJ node columns, CTE columns, or subquery columns. These expanded columns are saved to a node revision's associated columns, but in the saved query, we keep the wildcard syntax (i.e., we always preserve what the user wrote).

During node updates, we also update these columns based on the parent nodes' columns, if any has changed.

Test Plan

Deployment Plan

netlify[bot] commented 1 month ago

Deploy Preview for thriving-cassata-78ae72 canceled.

Name Link
Latest commit 0734396983dd424eb93e527036814f43750eaf04
Latest deploy log https://app.netlify.com/sites/thriving-cassata-78ae72/deploys/665e8a9992c45a0008796a85