I haven't tested the projection (beware of correctly escaping the dollar and the

\1

), but I did test the sql in postgres.