On your third note of above reply i.e. Fetch the record details of the profile.   I am able to fetch the details of single profile using select query but when I try to delete a profile using delete query It is throwing an error (ErrorCode: 42601 Syntax error encountered. Reason: [Invalid command!]) ...

Using API, I want to do below Get the list of profiles qualified in a segment. Delete a specific profile from this list. Fetch the record details of the profile.  

Can we use queries to fetch segment's all attributes in AEP ?. and I also find some auto suggested table name in Queries like (segment_ingestion_dataset, segment_export_dataset) where does it come from as there is no such dataset present with this names.