Bits of .NET

The Problem: You stored a JSON blob in a text column and need to query a specific property without writing a backend script.

The Fix: Use OPENJSON or JSON_VALUE (SQL Server 2016+).

-- Extract specific property from JSON column
SELECT 
    JSON_VALUE(SettingsColumn, '$.theme') AS UserTheme
FROM UserPreferences
WHERE JSON_VALUE(SettingsColumn, '$.isActive') = 'true';