René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[FEATURE] Support composability of views, materialised views, subqueries and user space tables.","articleBody":"**Feature Description**\n\nOn ought to be able to select from joins of views, materialised views, subqueries and user space tables.\n\n\n\n\n**Example(s)**\n\nPlease contrive from reality.  This will form the basis of robot regression testing.\n\n**Possible Approaches or Libraries to Consider**\n\nSee below.\n\n**Additional context**\n\nUnfortunately the data flow analysis is interwoven into multiple passes so this will not be simple.  The high level expectation is that data flow analysis is not skipped or weakened.  Views have the \"novel\" feature that where clauses can be rewritten externally, complicating matters.\n\nHere is an illustrative example in a stackql shell session:\n\n\n```\n\nstackql  \u003e\u003edescribe google.storage.buckets;\n|-----------------------|---------|\n|         name          |  type   |\n|-----------------------|---------|\n| id                    | string  |\n|-----------------------|---------|\n| name                  | string  |\n|-----------------------|---------|\n| acl                   | array   |\n|-----------------------|---------|\n| autoclass             | object  |\n|-----------------------|---------|\n| billing               | object  |\n|-----------------------|---------|\n| cors                  | array   |\n|-----------------------|---------|\n| customPlacementConfig | object  |\n|-----------------------|---------|\n| defaultEventBasedHold | boolean |\n|-----------------------|---------|\n| defaultObjectAcl      | array   |\n|-----------------------|---------|\n| encryption            | object  |\n|-----------------------|---------|\n| etag                  | string  |\n|-----------------------|---------|\n| generation            | string  |\n|-----------------------|---------|\n| hardDeleteTime        | string  |\n|-----------------------|---------|\n| hierarchicalNamespace | object  |\n|-----------------------|---------|\n| iamConfiguration      | object  |\n|-----------------------|---------|\n| ipFilter              | object  |\n|-----------------------|---------|\n| kind                  | string  |\n|-----------------------|---------|\n| labels                | object  |\n|-----------------------|---------|\n| lifecycle             | object  |\n|-----------------------|---------|\n| location              | string  |\n|-----------------------|---------|\n| locationType          | string  |\n|-----------------------|---------|\n| logging               | object  |\n|-----------------------|---------|\n| metageneration        | string  |\n|-----------------------|---------|\n| objectRetention       | object  |\n|-----------------------|---------|\n| owner                 | object  |\n|-----------------------|---------|\n| projectNumber         | string  |\n|-----------------------|---------|\n| retentionPolicy       | object  |\n|-----------------------|---------|\n| rpo                   | string  |\n|-----------------------|---------|\n| satisfiesPZI          | boolean |\n|-----------------------|---------|\n| satisfiesPZS          | boolean |\n|-----------------------|---------|\n| selfLink              | string  |\n|-----------------------|---------|\n| softDeletePolicy      | object  |\n|-----------------------|---------|\n| softDeleteTime        | string  |\n|-----------------------|---------|\n| storageClass          | string  |\n|-----------------------|---------|\n| timeCreated           | string  |\n|-----------------------|---------|\n| updated               | string  |\n|-----------------------|---------|\n| versioning            | object  |\n|-----------------------|---------|\n| website               | object  |\n|-----------------------|---------|\nstackql  \u003e\u003eselect name, updated from google.storage.buckets where project = 'stackql-demo';\n|----------------------------------|--------------------------|\n|               name               |         updated          |\n|----------------------------------|--------------------------|\n| demo-app-bucket1                 | 2025-08-03T07:01:59.323Z |\n|----------------------------------|--------------------------|\n| demo-app-bucket2                 | 2025-08-03T07:01:59.758Z |\n|----------------------------------|--------------------------|\n| silly-bucket-st-demo-001         | 2026-02-26T22:39:28.525Z |\n|----------------------------------|--------------------------|\n| silly-bucket-st-demo-002         | 2026-02-26T22:40:39.282Z |\n|----------------------------------|--------------------------|\n| stackql-demo-bucket              | 2025-08-03T07:01:59.747Z |\n|----------------------------------|--------------------------|\n| stackql-demo-src-bucket          | 2025-08-03T07:01:59.749Z |\n|----------------------------------|--------------------------|\n| stackql-demo.appspot.com         | 2025-08-03T07:01:59.818Z |\n|----------------------------------|--------------------------|\n| stackql-encrypted-bucket-1       | 2025-08-03T07:01:59.770Z |\n|----------------------------------|--------------------------|\n| stackql-rag-demo                 | 2025-11-09T21:57:24.135Z |\n|----------------------------------|--------------------------|\n| staging.stackql-demo.appspot.com | 2025-08-03T07:01:59.823Z |\n|----------------------------------|--------------------------|\nstackql  \u003e\u003ecreate or replace view vw1 as select name, updated from google.storage.buckets where project = 'stackql-demo';\nDDL Execution Completed\nstackql  \u003e\u003ecreate or replace materialized view mv1 as select name, updated from google.storage.buckets where project = 'stackql-demo';\nDDL Execution Completed\nstackql  \u003e\u003eselect * from vw1;\n|----------------------------------|--------------------------|\n|               name               |         updated          |\n|----------------------------------|--------------------------|\n| demo-app-bucket1                 | 2025-08-03T07:01:59.323Z |\n|----------------------------------|--------------------------|\n| demo-app-bucket2                 | 2025-08-03T07:01:59.758Z |\n|----------------------------------|--------------------------|\n| silly-bucket-st-demo-001         | 2026-02-26T22:39:28.525Z |\n|----------------------------------|--------------------------|\n| silly-bucket-st-demo-002         | 2026-02-26T22:40:39.282Z |\n|----------------------------------|--------------------------|\n| stackql-demo-bucket              | 2025-08-03T07:01:59.747Z |\n|----------------------------------|--------------------------|\n| stackql-demo-src-bucket          | 2025-08-03T07:01:59.749Z |\n|----------------------------------|--------------------------|\n| stackql-demo.appspot.com         | 2025-08-03T07:01:59.818Z |\n|----------------------------------|--------------------------|\n| stackql-encrypted-bucket-1       | 2025-08-03T07:01:59.770Z |\n|----------------------------------|--------------------------|\n| stackql-rag-demo                 | 2025-11-09T21:57:24.135Z |\n|----------------------------------|--------------------------|\n| staging.stackql-demo.appspot.com | 2025-08-03T07:01:59.823Z |\n|----------------------------------|--------------------------|\nstackql  \u003e\u003eselect * from mv1;\n|----------------------------------|--------------------------|\n|               name               |         updated          |\n|----------------------------------|--------------------------|\n| demo-app-bucket1                 | 2025-08-03T07:01:59.323Z |\n|----------------------------------|--------------------------|\n| demo-app-bucket2                 | 2025-08-03T07:01:59.758Z |\n|----------------------------------|--------------------------|\n| silly-bucket-st-demo-001         | 2026-02-26T22:39:28.525Z |\n|----------------------------------|--------------------------|\n| silly-bucket-st-demo-002         | 2026-02-26T22:40:39.282Z |\n|----------------------------------|--------------------------|\n| stackql-demo-bucket              | 2025-08-03T07:01:59.747Z |\n|----------------------------------|--------------------------|\n| stackql-demo-src-bucket          | 2025-08-03T07:01:59.749Z |\n|----------------------------------|--------------------------|\n| stackql-demo.appspot.com         | 2025-08-03T07:01:59.818Z |\n|----------------------------------|--------------------------|\n| stackql-encrypted-bucket-1       | 2025-08-03T07:01:59.770Z |\n|----------------------------------|--------------------------|\n| stackql-rag-demo                 | 2025-11-09T21:57:24.135Z |\n|----------------------------------|--------------------------|\n| staging.stackql-demo.appspot.com | 2025-08-03T07:01:59.823Z |\n|----------------------------------|--------------------------|\nstackql  \u003e\u003eselect vw1.name as vn, mv1.updated as mvu from vw1 inner join mv1 on vw1.name = mv1.name;\nalias 'vw1' does not map to any table expression\n\n```\n","author":{"url":"https://github.com/general-kroll-4-life","@type":"Person","name":"general-kroll-4-life"},"datePublished":"2026-03-26T06:14:51.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/629/stackql/issues/629"}