Can't create SQLite tables with auto increment_columns

[timint]

Preconditions
HeidiSQL 12.0.0.6468
Windows 11 64-bit

Describe the bug
Assigning auto_increment to a table column causes a malfunction.

To Reproduce
Create a table with an auto increment column
This produces the following query:

CREATE TABLE "foo2" (
	"id" INTEGER NOT NULL AUTO_INCREMENT,
	"foo" TEXT NOT NULL DEFAULT ''
);

Screenshots or Crash reports

Documentation:
https://www.sqlitetutorial.net/sqlite-autoincrement/