Expanding on the regex trick: I often use [.] instead of \. to match a period. They achieve the same thing, but [.] avoids the problem of your host language "h

Expanding on the regex trick: I often use [.] instead of \. to match a period. They achieve the same thing, but [.] avoids the problem of your host language "helpfully" interpolating \. into . before sending the query to Postgres.