There are times when I need to delete some, but not all, records from a table with a certain condition. (ex. Delete from my_table where field1=245).
Currently this can only be accomplish by looping the values and issuing individual delete record statements. For large datasets, this becomes inefficient.
Thus being able to delete records with a conditional through the interface would be desired.