Using a pivot and bloomberg formula of DAYS_TO_MTY_TDY i am able to then break down to estimated months to maturity but this is not concise enough.

=BQL("filter(bondsuniv('active',INCLUDEPRELIMINARYSECURITIES='Y'),SRCH_ASSET_CLASS=='Corporates' AND BETWEEN(MATURITY,6M,12M))","id_isin") but this too exhaustive as i am searching for specific bonds in an index universe.