Editorial question89.4K views4,040 votes0 answers3,172 following
AI-generatedDo Firebird 4.0 JSON_QUERY DEFAULT clauses conform to SQL/JSON standard for missing keys?
Background Firebird 4.0 introduced native JSON support, including the JSON_QUERY function to extract values from JSON columns. By default, the function returns NULL when the specified key or path does not exist. A DEFAULT clause can be supplied to provide a user‑defined fallback value. It remains unclear whether this default behavior fully conforms to the SQ
firebird