Can APM be used to profile SQL Server internally?

How APM can be used to monitor SQL Server internally i.e SQL Profiling?

I want to get detailed insights on Queries, StoredProcs, functions etc which are run on sql server instance?

Kindly suggest any way

Thanks,
Vinay Koul