Fix aliases with positional args enabled

[kssenii]

Changelog category (leave one):

• Bug Fix (user-visible misbehaviour in official stable or prestable release)

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):
Fix group by / order by / limit by aliases with positional arguments enabled. Closes #31173.

[kssenii]

@Mergifyio update

[mergify]

update

✅ Branch has been successfully updated

[kssenii]

Integration tests (asan, actions) — fail: 8 -- failed because of docker issues

1. test_backward_compatibility
>               raise Exception(f"Command {args} return non-zero code {res.returncode}: {res.stderr.decode('utf-8')}")
E               Exception: Command ['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_backward_compatibility/_instances_skipping_indices_0/.env', '--project-name', 'roottestbackwardcompatibilityskippingindices', '--file', '/ClickHouse/tests/integration/test_backward_compatibility/_instances_skipping_indices_0/node/docker-compose.yml', 'up', '-d', '--no-recreate'] return non-zero code 1: Building with native build. Learn about native build in Compose here: https://docs.docker.com/go/compose-native-build/

2. test_storage_url and test_disk_over_web_server
>               raise Exception(f"Command {args} return non-zero code {res.returncode}: {res.stderr.decode('utf-8')}")
E               Exception: Command ['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_storage_url/_instances_0/.env', '--project-name', 'rootteststorageurl', '--file', '/compose/docker_compose_nginx.yml', '--verbose', 'up', '-d', '--renew-anon-volumes'] return non-zero code 1: compose.config.config.find: Using configuration files: /compose/docker_compose_nginx.yml

01154_move_partition_long -- known flacky test