@f6217321 Oh, now this is a pretty old version of the JSON1 extension. Maybe not all JSON features are available 🤔 if you have some time, I'd be glad to help you gathering the availability of individual JSON SQL functions on various macOS versions! 

 @8c08de26 Sure. Send me the SQL statement to validate and I will run it on each OS version I have and report back in a concise table. 😉 

 @f6217321 Here is a gist that tests the presence of JSON functions: https://gist.github.com/groue/046ebddb4a410304094c022d756081c8 Unexpected results are reported as XCTest failures. I hope it will be handy for you! 

 @8c08de26 wow 👍thanks for that. Will package it, with a nice icon 😉, and run it on all our instances.