fix(spec)!: refuse multiple: true outside the multi-capable types, and derive driver-sql's storage from the spec predicate

fix(spec)!: refuse multiple: true outside the multi-capable types, and derive driver-sql's storage from the spec predicate #10318