Hi Matteo - you can delete all records via an API ( Delete all records using Tulip API - Support, Troubleshooting, & App Help - Tulip Community), however I don’t think you can use that to select distinct records which isn’t ideal.
Would be good if there was a more defined DB language that could perform some essential admin activities such as this, though I also understand the need for control and compliancy.
For any of the Tulip Team reading this - are there any plans to improve this part of the functionality?