// assuming FDConnection is a connection for FDQuery
FDConnection.Params.Add('DriverID=SQLite');
FDConnection.Params.Add('Database=C:\MyData.db');

FDQuery.Close;
FDQuery.SQL.Text := 'CREATE TABLE MyTable (Col1 REAL, Col2 TIME)';
FDQuery.ExecSQL;