You can use the SELECT statement to retrieve data from JSON columns.
In field mode, the SELECT result is always a string, even if it is filtered using one of the JSON methods.
If a string is not the desired format, you must cast the result set to the proper data type it represents.
In non-field mode, the JSON type is returned to the client.
Retrieval of data from a JSON column stored as BSON or UBJSON will always result in a conversion of the data to its text format.
You cannot include a JSON column in the ORDER BY, HAVING or GROUP BY clauses of a SELECT statement.
In the SELECT or WHERE clause, you can add a JSON entity reference to the end of a column reference or any expression which evaluates to a JSON type.