Also wanted to find a way to limit results to only products that are available for purchase. This is important for us because although we do not sell products after they are continued, we keep the pages enabled for documentation purposes. Filtering out products that are not purchasable would allow us to provide users with only products that are relevant and available.

I'd really appreciate this being merged in as we'd love to use this on our site but can't while it's coming up with this error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'purchase_counts.order_count' in 'field list'

Closing this as I've manually merged the fix into the next release.

I haven't merged the limit to available part since you can already do this. Both craft.purchasePatterns.related and extended return a regular Commerce Product Query so you can use the existing availableForPurchase param.

{% set products  = craft.purchasePatterns.related(myProduct).availableForPurchase().all() %}