migrations: Add `IndexStatus` to store
Created by: efritz
Pulled from #29831. This PR introduces as (currently unused) IndexStatus
method that returns the current status of a particular database index by name. This includes whether or not the index is invalid, or if it's creation operation is currently in-progress. This will later be used to determine if a concurrent index creation operation is ongoing without necessitating an advisory lock.