ASTA SQL Generation
ASTA can generate SQL either on the client or on an ASTA server. You may configure ASTA to generate SQL according to your database requirements.There are several properties and events that can be changed to customize your SQL syntax. The following properties and events are available on the client using a TAstaClientSocket and on the server using an TAstaSQLGenerator.
When SQL is used on the client, SQL for inserts, updates and deletes is generated by ASTA and posted to the server. When there is NO SQL on the client, inserts, updates and deletes are accomplished by sending an OldValueDataSet and a CurrentValueDataSet to TAstaProviders which generate SQL on the server and provide events that you can code to get "in between" this SQL generation.
See also More on SQL Generation.