René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[FEATURE] Support for scalar functions in outer query columns in a subquery","articleBody":"**Feature Description**\r\nIt would help to reduce repeated code if we could use scalar functions in the column list in the outer query in a subquery, for instance:\r\n\r\n```sql\r\nSELECT \r\nname,\r\niif(isResidencyRestricted = 0, 'false', 'true') as isResidencyRestricted,\r\nbackupStorageRedundancies,\r\nsupportsAvailabilityZone \r\nFROM (\r\n    SELECT \r\n    name,\r\n    json_extract(properties, '$.isResidencyRestricted') as isResidencyRestricted,\r\n    json_extract(properties, '$.supportsAvailabilityZone') as supportsAvailabilityZone,\r\n    json_extract(properties, '$.backupStorageRedundancies') as backupStorageRedundancies \r\n    FROM azure.cosmos_db.locations \r\n    WHERE subscriptionId = '631d1c6d-2a65-43e7-93c2-688bfe4e1468'\r\n) AS virtual_table;\r\n```\r\ncurrently this is not supported, however it works if you remove the function, e.g.:\r\n\r\n```sql\r\nSELECT \r\nname,\r\nisResidencyRestricted,\r\nbackupStorageRedundancies,\r\nsupportsAvailabilityZone \r\nFROM (\r\n    SELECT \r\n    name,\r\n    json_extract(properties, '$.isResidencyRestricted') as isResidencyRestricted,\r\n    json_extract(properties, '$.supportsAvailabilityZone') as supportsAvailabilityZone,\r\n    json_extract(properties, '$.backupStorageRedundancies') as backupStorageRedundancies \r\n    FROM azure.cosmos_db.locations \r\n    WHERE subscriptionId = '631d1c6d-2a65-43e7-93c2-688bfe4e1468'\r\n) AS virtual_table;\r\n```","author":{"url":"https://github.com/jeffreyaven","@type":"Person","name":"jeffreyaven"},"datePublished":"2023-03-03T03:28:43.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/161/stackql/issues/161"}