JSON to CASE WHEN THEN SQL block in one step
Converts a JSON-like object of "key": "value" pairs into a SQL CASE statement using a single regex replace with named conditional groups.
✅ Works in PCRE2 flavor only.
🚫 Will not work in JavaScript, Python <3.12, or other engines without conditional replacements.
Submitted by Moron - 3 months ago