@blogyturf - the API is there to support plugins. You can do anything you want with plugins. Any software that required you to muck around with the database would be a nightmare to maintain.

As an example, there is a guid plugin that allows you to view each object in the elgg database and delete if desired.

ok so I have to learn to create an API to suit my needs ... I am not against but for a turnkey platform as elgg I think it's limits.
Then I have the link to the api guide to see the objetcts and remove them please?
Thank you

Elgg is *not* a turnkey platform.