Move missing schema alert from engine to client

having the alert in engine makes it unskippable, which
disrupts the utility of setting yes=True like on every
other command that asks for confirmation. Moving it to
client makes it so that y=True bypasses the alert.