Direct SQL access


Is there a standard way on Aurelius that I could send a complete SQL sentence to be executed on the database?

The fact is that I could be using SQLite or Elevatedb or RemoteDB. I want to pass a specific SQL sentence independent of each driver in use. Sure I need to be careful about the cross compatibility of SQL syntax.

Yes, using IDBConnection:

  MyConn: IDBConnection;
  Stmt: IDBstatement;
  Stmt := MyConn.CreateStatement;
  Stmt.SetSQLCommand('INSERT INTO BLA...');