I think SQL is pretty good but I would like to see a tighter integration with the application code and the database. Like managing the database source in the repository, integrate the database into tests easier, maybe express queries in the application language instead of SQL. You can do all of these to to some degree with things like ORM and LINQ but the database still feels very separate from the rest of the project.
I think SQL as a language could also be improved a lot to make it easier to understand. It looks and feels like FORTRAN 77.
I think SQL as a language could also be improved a lot to make it easier to understand. It looks and feels like FORTRAN 77.