Problem Parsing colons and periods within backticks

[ConnorLeggettQC]

Description

Backticks do not parse correctly when a colon (:) is placed after a period (.) within backticks (`) .

For example:

[stoeppke]

Kind of the same issue:

Code example

-- BigQuery
-- selected Language: sql-bigquery

WITH _start AS (SELECT '',), -- noqa: LT02, ST03

--> raw tables
    jobs AS (
        SELECT
            total_slot_ms,
            reservation_id,
            state,

        FROM `PROJECT_ID`.`region-REGION_NAME`.INFORMATION_SCHEMA.JOBS
        WHERE 1 = 1
            AND creation_time BETWEEN TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 DAY) AND CURRENT_TIMESTAMP()
    ),

_end AS (SELECT '',) -- noqa: LT02, ST03

SELECT *,
FROM jobs
LIMIT 10

Looks good when

the first `` block got no -

`PROJECT_ID`.`region-REGION_NAME`.INFORMATION_SCHEMA.JOBS

Looks bad when

the first `` block got a -

`PROJECT-ID`.`region-REGION_NAME`.INFORMATION_SCHEMA.JOBS

In addition

The second `` block dose not have a problematic impact, there - or _ both are fine

`PROJECT_ID`.`region-REGION_NAME`.INFORMATION_SCHEMA.JOBS
`PROJECT_ID`.`region_REGION_NAME`.INFORMATION_SCHEMA.JOBS