SQLite3 release 3.25 and higher allows me to
"ALTER TABLE myTable RENAME COLUMN oldColName TO newColName". But I get an error
"near RENAME" when I execute this in my Delphi code, but it works running the new sqlite3.dll from the command line or with another utility.
HerdConnection.ExecSQL('ALTER TABLE myTable RENAME TO NewNameTable');
HerdConnection.ExecSQL('ALTER TABLE myTable RENAME COLUMN oldcolName TO NewColName');
Since i installed the new sqlite3.dll driver, the column re-name does work, but NOT in my Delphi code (Delphi 10.2 Update 2)
I suspect the included sqlite3 driver with FireDac is not up to date, but have switched to the newest sqlite3.dll everywhere on the computer i can find.