PG->Fabric (T-SQL): `pg_typeof()` 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)
SELECT pg_typeof(a) FROM t	SELECT PG_TYPEOF(a) FROM t

Defect: PG catalog function with no T-SQL equivalent → Msg 195.

Fix: fail-fast under strict() (no faithful equivalent; SQL_VARIANT_PROPERTY(a,'BaseType')
only works for sql_variant).

[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 pg_typeof(a) FROM t	SELECT PG_TYPEOF(a) FROM t	raises: Unsupported: PostgreSQL PG_TYPEOF is not supported in fabric

pg_typeof (no T-SQL equivalent) now fail-fasts under strict().

Closing as resolved. Thanks for the fix!