> I haven’t seen one yet that can run a query to determine if a migration has been applied or not

Entity Framework (both Core and legacy) does that, also DbUp uses migrations table for those that prefer lighter ORMs.