Announcing fixSQL v1.2: Message Explainer, Export, and Order Lifecycles

fixSQL 1.2 introduces three new capabilities for working with FIX data at the message level: semantic message decoding, TagValue export, and order lifecycle reconstruction.

The new explain-message command renders an encoded FIX message as a table, translating wire values into their semantic names and joining each field with documentation. It supports repeating groups as well as fields with multiple values.

The export command translates the output of a SQL query against a fixSQL index table back into TagValue-encoded messages. Because the export is driven by a SQL query, columns can be filtered, transformed, or redacted on the way out. Common uses include producing masked traffic for testing, generating curated datasets for investigations, and sharing samples in their native wire format.

The release also adds an experimental order lifecycle reconstruction utility. It traces the messages that pertain to a single order across its life, linking creation, fills, cancellations, and replacements into a single history. Reviewing what happened to an order no longer requires stitching the chain together from raw logs.

Key additions in v1.2 include:

• Semantic message explainer with support for nested repeating groups and multi-value fields
• Export of query results back into TagValue encoding, useful for data masking and sample generation
• Experimental reconstruction of an order's full lifecycle from raw FIX messages