SQLite released version 3.44 with major fixes and enhancements

SQLite released version 3.44 with major fixes and enhancements.

Below are few important updates

Aggregate functions in the query which used to aggregate the results set can now include an ORDER BY clause. This is a most important feature as the results will get sorted.

In Scalar SQL functions, added support for concat() and concat_ws(), the function concatenates the non-NULL arguments

Add new C-language APIs: sqlite3_get_clientdata() and sqlite3_set_clientdata(), These functions are used to associate one or more named pointers with a database connection. A call to sqlite3_set_clientdata(D,N,P,X) causes the pointer P to be attached to database connection D using name N. Subsequent calls to sqlite3_get_clientdata(D,N) will return a copy of pointer P or a NULL pointer.

The PRAGMA integrity_check command (low-level formatting and consistency check of the database) now verifies the consistency of the content in various built-in virtual tables like FTS3, FTS4, FTS5, RTREE, and GEOPOLY extensions.

Query planners are optimized to disable the view-scan and in partial index scans, if the WHERE clause implies a constant value for a table column, replace occurrences of that table column with the constant.

The CLI for Windows now defaults to using UTF-8 for both input and output on platforms that support it.