Please add option to clear the target before insert

[Tauvic]

For ETL it can be useful to clear the destination before inserting.
Then we can do load, transform and dump the result.

For some processing i don't want to do upsert kind of insertion.
Just a plain clear the target and insert is also very usefull.

[gacarrillor]

Well, you could create a model adding the "Truncate table" algorithm as a first step.

However, I'll leave this feature request open to see if other users find it interesting. If so, I could implement it.

[Tauvic]

Hi, fast response. Did not know about the truncate trick. Now i found it.
Great work its very useful. Im making a map on playgrounds and the ETL approach is a big help.

!(image)[https://tauvicr.files.wordpress.com/2021/11/qgis_buurtkaart-1.png]