PG->Fabric (T-SQL): PostgreSQL `format()` printf function mis-mapped to T-SQL `FORMAT`

[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 (approx.)
SELECT format('%s-%s', a, b) FROM t	SELECT FORMAT('%s-%s', a, b) FROM t	SELECT CONCAT(a, '-', b) FROM t

Defect: PG format(fmt, args…) is printf-style; T-SQL FORMAT(value, format[, culture])
takes a value first. FORMAT('%s-%s', a, b) is nonsensical (3 args, string first) and doesn't
interpolate.

Root cause: the same TO_CHAR/DATE_FORMAT→FORMAT renaming path (tsql.rs:1725+) collides
with PG's unrelated format().

Fix: translate format() with %s/%I/%L specifiers into CONCAT/quoting; do not route it
through T-SQL FORMAT.

[NivasSA]

Another repro below

Repro query

SELECT format('x=%s', f1) FROM text_tbl;

Actual: Fabric Msg 8116 "Argument data type varchar(max) is invalid for argument 1 of format function" (XX000).

Expected: clean plan-time decline, SQLSTATE 0A000 (T-SQL has no printf-style format()).

Emitted T-SQL

SELECT FORMAT('x=%s', f1) FROM fabric_canonical.text_tbl;   -- T-SQL FORMAT != PG printf format

[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 format('%s-%s', a, b) FROM t	SELECT CONCAT(a, '-', b) FROM t	SELECT CONCAT(a, '-', b) FROM t

PostgreSQL format('%s-%s', a, b) now lowers to CONCAT(a, '-', b) instead of T-SQL FORMAT.

Closing as resolved. Thanks for the fix!