[Lazarus] Generate InsertSQL, UpdateSQL, DeleteSQL

[Michael Van Canneyt]

On Wed, 8 Apr 2020, Santiago A. via lazarus wrote:

> Hello:
>
> I have a TSQLQuery with a SQL string like this "select * from 
> manyFieldsTable" and I want to write a custom updateSQL, but I don't 
> want to start from scratch, from an empty script.  I want to start from 
> the automatically generated updateSQL statement that TSQLQuery generates 
> when you leave the UpdateSQL script blank.
>
> Is there any way I can get the automatically generated updateSQL 
> statement, edit it and set the UpdateSQL property?

I use the lazarus database desktop for this, it can generate such queries.
It should not be too hard to integrate the "generate SQL" dialog as a TSQLQuery
component editor dialog (it's been on my TODO list for very long...)

Michael.