SQLite’s json_valid() function allows us to check whether a JSON string is well formed or not.
Prior to SQLite 3.45.0 the json_valid() function only accepts one argument – the value to check. However, from SQLite 3.45.0 (released on 15 January 2024), we can now provide an optional second argument to define what valid – or “well formed” – means.
Many RDBMSs implement IF EXISTS and IF NOT EXISTS syntax modifiers that can be used with DDL object creation, modification, and deletion, such as CREATE TABLE and DROP TABLE statements, to name just a couple.
These syntax modifiers allow us to run such statements without getting an error in the event that the object already exists (if we’re trying to create it or modify it) or doesn’t exist (if we’re trying to drop it).
Continue readingThe release of SQL Server 2022 in November 2022 introduced a bunch of new functionality, including some enhancements to the TRIM(), LTRIM() and RTRIM() functions.
The enhancements in the LTRIM() and RTRIM() functions are different to those in the TRIM() function. Below is a quick overview of the enhancements to these functions, along with examples.
Starting with SQLite version 3.38.0 (released on 22 February 2022), we can now use the -> and ->> operators to extract subcomponents of JSON documents.
The aim with these operators is to be compatible with the equivalent MySQL and PostgreSQL operators.
Continue readingSQLite’s JSON functions and operators are now enabled by default, starting from SQLite 3.38.0 (released on 22 February 2022).
Continue readingSQLite has introduced the FORMAT() function, which can be used to format strings.
More precisely, it has actually just renamed its SQL PRINTF() function to FORMAT(). The reason is for better compatibility with other DBMSs. The original PRINTF() name is retained as an alias for backwards compatibility.
The FORMAT() function (or its naming) was introduced in SQLite 3.38.0, which was released on 22 February 2022.
The 10.6.0 release of MariaDB has added a JSON_TABLE() function.
The JSON_TABLE() function returns a representation of a JSON document as a relational table with the specified columns. It enables you to map JSON paths into relational columns to be returned in its results set.
The TO_CHAR() function has beeen introduced in MariaDB 10.6.1.