
Salesforce Tooling API’s SOQL capabilities for many metadata types allow us to retrieve metadata using queries.
Enable “Use Tooling API” to query setup objects in Developer console in Salesforce.

Please check the following link for the ApexCodeCoverageAggregate entity used in the above example.
Sample SOQLs:
Query to fetch Lightning Aura Components:
SELECT Id, DeveloperName, ApiVersion
FROM AuraDefinitionBundle
Query to fetch Lightning Web Components:
SELECT Id, DeveloperName, ApiVersion
FROM LightningComponentBundle