SQLITE ERROR in 4.3.8

Bug report

Required System information

• Node.js version: 16.13.1
• NPM version: 8.1.2
• Strapi version: 4.3.8
• Database: SQLITE
• Operating system: Debian 10 - Docker

Describe the bug

After the update from 4.3.6 to 4.3.8 it is impossible to create new documents or update existing ones. In the log an error is show like:

[2022-09-19 08:20:33.052] error: insert into urm_contacts (created_at, created_by_id, first_name, last_name, locked, published_at, updated_at, updated_by_id) values ('2022-09-19 08:20:33.049', 1, 'Hello', 'Master', false, NULL, '2022-09-19 08:20:33.049', 1) returning id - SQLITE_ERROR: near "returning": syntax error
Error: insert into urm_contacts (created_at, created_by_id, first_name, last_name, locked, published_at, updated_at, updated_by_id) values ('2022-09-19 08:20:33.049', 1, 'Hello', 'Master', false, NULL, '2022-09-19 08:20:33.049', 1) returning id - SQLITE_ERROR: near "returning": syntax error

After roll back to 4.3.6 everything works perfect like before.

Steps to reproduce the behavior

1. Update to version 4.3.8

Expected behavior

The message occurs in the logs.

[strapi-bot]

This issue has been mentioned on Strapi Community Forum. There might be relevant details there:

https://forum.strapi.io/t/issue-4-3-8-after-update-sqlite-error-near-returnin/22172/4

[alexandrebodin]

Hello @uniforx We have noticed this bug when using the older sqlite3 package in v4.3.7+ versions. We are going to add a migration guide about this but you can switch your sqlite3 package for better-sqlite3 like mentioned at the end of this issue. strapi/strapi#14193

Thank you for reaching out.

[derrickmehaffy]

Migrating this to the documentation repo as a migration guide needs to be created.

[stb13579]

This issue is closed by #1155