SOF-MSSQL

A TypeScript library and CLI tool (v2.2.0) for loading FHIR R4 resources into Microsoft SQL Server and transpiling SQL on FHIR v2 ViewDefinitions into T-SQL queries. It uses JSON_VALUE, JSON_QUERY, and OPENJSON for efficient query generation, supports FHIRPath expressions, array flattening via CROSS APPLY, and unionAll for polymorphic fields. Includes a bulk NDJSON loader with options for batching, parallel processing, and connection configuration via environment variables. Compatible with Node.js >=18.0.0 and ships TypeScript declarations.