PG->Fabric (T-SQL): `gen_random_uuid()` emitted verbatim

[VaibhaveS]

Found while transpiling PostgreSQL -> Microsoft Fabric (T-SQL) with polyglot-sql 0.5.15 (main 43a4458, latest release tag). Scope: SELECT queries only. Every "Actual" value was captured directly from transpile(sql, DialectType::PostgreSQL, DialectType::Fabric). Unless the table notes otherwise, each case also reproduces under Dialect::get(PostgreSQL).transpile_with(sql, Fabric, TranspileOptions::strict()). Cross-checked against the existing PostgreSQL->Fabric issue series (#257-#286) to avoid duplicates.

Failing SELECT query

Input (PostgreSQL)	Actual (invalid)	Expected
SELECT gen_random_uuid()	SELECT GEN_RANDOM_UUID()	SELECT NEWID()

Defect: not a Fabric/T-SQL built-in → Msg 195.

Fix: map gen_random_uuid() (and uuid_generate_v4()) → NEWID().

[tobilg]

This is fixed in the upcoming version 0.5.16 that will be available in approx. 2h

[VaibhaveS]

Verified fixed in polyglot-sql v0.5.16 (fixes landed in commit 5401d25 — "Fix issues #265, #269 to #314"). Re-ran every query from this issue against v0.5.16 in both default and TranspileOptions::strict() modes:

Input (PostgreSQL)	v0.5.16 default	v0.5.16 strict
SELECT gen_random_uuid()	SELECT NEWID()	SELECT NEWID()

gen_random_uuid()→NEWID().

Closing as resolved. Thanks for the fix!