snowflake - cte fix and ids #5085

Job	Run time
setup	15s
static-check (ubuntu-latest, useless-parens)	38s
static-check (ubuntu-latest, format)	29s
build-pwsh (macos-latest, Cpp)	3m 24s
build-pwsh (macos-latest, CSharp)	2m 49s
build-pwsh (macos-latest, Dart)	2m 24s
build-pwsh (macos-latest, Java)	2m 23s
build-pwsh (macos-latest, JavaScript)	2m 31s
build-pwsh (windows-latest, Cpp)	5m 39s
build-pwsh (windows-latest, CSharp)	4m 30s
build-pwsh (windows-latest, Dart)	4m 40s
build-pwsh (windows-latest, Java)	2m 53s
build-pwsh (windows-latest, JavaScript)	3m 12s
build-pwsh (ubuntu-latest, Cpp)	3m 8s
build-pwsh (ubuntu-latest, CSharp)	1m 47s
build-pwsh (ubuntu-latest, Dart)	1m 41s
build-pwsh (ubuntu-latest, Java)	1m 8s
build-pwsh (ubuntu-latest, JavaScript)	1m 44s
	45m 15s

Provide feedback