Yes, SQL engines tend to be much smarter than the SQL languages as such.