An aspiring page is a page that does not yet exist, but is already linked to.
Aspiring pages appear in the Page Picker (with a Create chip) as well as in auto complete when creating Link.
Every [link](</Object/link>) to a non-existent page produces an aspiring-page object in the Object Index, so you can query them to audit broken or forward-references:
${query[ from t = index.aspiringPages() where not string.startsWith(t.page, "Library/") select { target = t.name, linkedFrom = t.page } ](< from t = index.aspiringPages() where not string.startsWith(t.page, "Library/") select { target = t.name, linkedFrom = t.page }
)}
In this query, t.name is the link target (the page that does not yet exist); t.page is where the link lives (the source page). Filter on t.page to scope results to your own content.
Triage guidance: