Re: Prepared_Statement :(

[briot.emmanuel@gmail.com]

> Ergo, if you can, never use any DB-specific bindings, use ODBC. It is 
> not portable across RDBMs either (SQL is very not Ada (:-)), but at 
> least it would give you far less headache...

Alternatively, use GNATCOLL and let it do the formatting for you. The OP
query could be written as :

  with Database;  --  generated via gnatcoll_db2ada
  declare
      PS     : Prepared_Statement  := Prepare(
         SQL_Insert
             ((Database.Exmo.Trades.Trade_Id = Integer_Param (1))
              & (Database.Exmo.Trades.Pair = Integer_Param (2))
              & ...));
  begin
      --  actual execution remains the same
  end;

Then whether you use sqlite, postgresql, or add a new backend to gnatcoll, the
code remains valid.

All of these are valid choices, and depends on your workflow