By default, Delphi 10.4 will require you to supply a
sqlite3.dll along with your executable to be able to connect to an SQLite database using FireDAC. This is fine if you’re used to supplying extra files in an installer, but can be quite annoying for existing projects that never needed this when it was compiled with Delphi 10.3
To make the compiler link the SQLite code directly into your executable, you can use the unit
FireDAC.Phys.SQLiteWrapper.Stat . This way the executable won’t require the
sqlite3.dll to run.
For more information go here https://docwiki.embarcadero.com/RADStudio/Sydney/en/Connect_to_SQLite_database_(FireDAC)