New Features

Type tag support:

• Added tag array to ViewDefinitionColumn for type hints
• Two tag types supported:
  • tsql/type - Direct T-SQL type specification (e.g., DATE, VARCHAR(50))
  • ansi/type - ANSI/ISO SQL standard types, auto-converted to T-SQL (e.g., INTEGER → INT, BOOLEAN → BIT)
• Type precedence: tsql/type > ansi/type > FHIR defaults

Example:

{
  "name": "birthDate",
  "path": "birthDate",
  "tag": [{ "name": "tsql/type", "value": "DATE" }]
}

Improvements

• Enhanced SQL injection protection with comprehensive validation
• Better identifier validation for resource types and column names

Breaking Changes

⚠️ Default column type mappings have changed significantly:

• Temporal types (date, datetime, instant, time) now use VARCHAR instead of native SQL types to preserve FHIR semantics (partial dates, timezone precision)
• decimal now uses VARCHAR(MAX) instead of DECIMAL(18,6) to support arbitrary precision
• id, uuid, oid now use VARCHAR with size constraints instead of NVARCHAR(MAX)

Fixed problem with missing production dependency for load script.