fix(schema-compiler): Undefined columns for pre lambda agg queries referencing dims from joined cubes

[KSDaemon]

This PR fixes the incorrect SQL query generation for queries using preaggregation with type: rollup_lambda, which include dimensions from the joined cubes.

Check List

• [x] Tests has been run in packages where changes made if available
• [x] Linter has been run for changed code
• [x] Tests for the changes have been added if not covered yet
• [ ] Docs have been added / updated if required

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

8 Skipped Deployments

| Name | Status | Preview | Comments | Updated (UTC) | | :--- | :----- | :------ | :------- | :------ | | **examples-angular-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-angular-dashboard/7FrgkvCQp45JzePj9zy7Tx4MkJ3n)) | [Visit Preview](https://examples-angular-dashboard-git-fix-undefined-ro-075a74-cube-dev.vercel.app) | | Nov 12, 2024 7:49pm | | **examples-react-d3** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-d3/3odaQEX6aDnZAndLUpNYNq9Wn5au)) | [Visit Preview](https://examples-react-d3-git-fix-undefined-rollup-lamb-9ce4bb-cube-dev.vercel.app) | | Nov 12, 2024 7:49pm | | **examples-react-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-dashboard/HLPgAsRmwTff68TYZ5GvBT2KZWMS)) | [Visit Preview](https://examples-react-dashboard-git-fix-undefined-roll-c82c77-cube-dev.vercel.app) | | Nov 12, 2024 7:49pm | | **examples-react-data-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-data-table/5ECMTC98hG9U7BDghWTB2qmWsS2W)) | [Visit Preview](https://examples-react-data-table-git-fix-undefined-rol-5781d1-cube-dev.vercel.app) | | Nov 12, 2024 7:49pm | | **examples-react-highcharts** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-highcharts/ADGVa46DFpqTAWa5U8qgb3DyuKqx)) | [Visit Preview](https://examples-react-highcharts-git-fix-undefined-rol-e1a7c8-cube-dev.vercel.app) | | Nov 12, 2024 7:49pm | | **examples-react-material-ui** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-material-ui/7FjM5SW1fYoJJQVdWA7o5cE8VERX)) | [Visit Preview](https://examples-react-material-ui-git-fix-undefined-ro-f11947-cube-dev.vercel.app) | | Nov 12, 2024 7:49pm | | **examples-react-pivot-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-pivot-table/EFX5X6aP9KStqbLmjLNgv4Uqwyv5)) | [Visit Preview](https://examples-react-pivot-table-git-fix-undefined-ro-fdcb6d-cube-dev.vercel.app) | | Nov 12, 2024 7:49pm | | **examples-vue-query-builder** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-vue-query-builder/Acipd4E73zqKMwivK3E4TYv5TFSr)) | [Visit Preview](https://examples-vue-query-builder-git-fix-undefined-ro-edb3f8-cube-dev.vercel.app) | | Nov 12, 2024 7:49pm |