v.24.12Improvement

Support JSON Type in notEmpty Function

Support JSON type in the notEmpty function. #72741 (Pavel Kruglov).
Support for the JSON data type in the notEmpty function was added.

Why it matters

This feature allows users to use the notEmpty function to check if JSON values are non-empty, enabling better handling and filtering of JSON data within queries.

How to use it

Simply apply the notEmpty function to columns or expressions of JSON type in your queries, for example:
sql<br>SELECT * FROM table WHERE notEmpty(json_column)<br>