2 ms·
> Isn't there a useful SQL subset which allows you to switch from one database to another without rewriting? Only if you're happy throwing away a lot of the fe
by emodendroket 6y ago
> Isn't there a useful SQL subset which allows you to switch from one database to another without rewriting?
Only if you're happy throwing away a lot of the features, which is taking away from what makes SQL an attractive solution in the first place. Plus, even some basic things aren't the same between different implementations (e.g., SELECT TOP 1 * FROM t vs SELECT * FROM t LIMIT 1), so you'd really have to be testing with different RDBMSes the whole way through to make sure you didn't accidentally break compatibility.