Goal

Adapt subscription manager queries that read Host Based Inventory database to new DB schema

Description

Host Based Inventory has refactored the database and extracted the host.system_profile column into it's own tables and hosts.facts into separate columns on the host table itself.

We need to change subman queries to adjust to this new structure.

Example queries (probably not all of them):

https://github.com/RedHatInsights/rhsm-subscriptions/blob/e2044ddb3aa25bff667bee9be2d143626fcd3be7/src/main/java/org/candlepin/subscriptions/inventory/db/model/InventoryHost.java#L157

https://github.com/RedHatInsights/rhsm-subscriptions/blob/e2044ddb3aa25bff667bee9be2d143626fcd3be7/src/main/java/org/candlepin/subscriptions/inventory/db/InventoryRepository.java