Differences in escape sequences from query service

The following two queries differ in their output on analytics and query service.

select 'Hello\"World'
– returns lexical error on Analytics works fine on Query

select "Hello\'World"
– returns lexical error on Analytics works fine on Query

select "Hello""World"
– runs fine on Analytics returns lexical error on Query