Parse T-SQL binary field with Python and save as file

parser.py

import csv
import sys

# Can be required if files are large
csv.field_size_limit(sys.maxsize)


def parse_hex(val: str):
    return bytes.fromhex(val)


def convert(output_path: str):
    with open('./Records.csv') as csvfile:
        lines = csv.DictReader(csvfile, delimiter=',')
        for row in lines:
            hexdata = row['data'].replace('0x', '') # feels a bit hacky
            
            if len(data_list) % 2:
                print('Warning: Found a potential partial file. SQL export might have truncated the file column')
                
            data = bytes.fromhex(data_list)
            with open(row['id'], 'wb') as f:
                f.write(data)

query.sql

SELECT [id]
      ,[data]
      -- Uncomment the hack below if data fields are truncated
      -- ,cast(convert(varchar(max), [data], 1) as xml) as data
  FROM [dbo].[FileTable];

Records.csv