The following query has the ability to list all Software Releases and their associated rules or just the rules associated with a specifc Software Release:
SELECT rsr.Name AS [Software Release],rir.Name AS [Rule],rir.[Description] AS [Rule Description] FROM RM_ResourceSoftware_Release rsr JOIN ResourceAssociation ra ON ra.ParentResourceGuid = rsr.[Guid] JOIN RM_ResourceInventory_Rule rir ON rir.[Guid] = ra.ChildResourceGuid --WHERE rsr.Name = 'specific software release' ORDER BY rsr.Name ASC
As Applicability and Detection rules are both classed as inventory rules, they do not have their own resource type or class; however, it does appear that detection rule names begin with "Detection Rule for", which should allow you to distinguish between the two.
Other detection rule names will have "Detection Rule" at the end of the name.