I loaded a large JSON file in Python and watched memory jump from 43 MB to 808 MB. Here’s what happened and how streaming changed everything.

Microsoft SQL 2016 and later versions and Azure SQL provide JSON support through functions that operate on nvarchar columns. The mssql-python driver sends and receives JSON as regular Python strings.