I guess I should qualify my statement better. You are expected to know both frontend and backend, in interview or daily work, to the same degree of a frontend engineer and a backend engineer respectively.
I would expect an SQL specialist to know more about SQL than a backend engineer. But that's a different scope all together.