Ordinal number on consequent values in SQL

I have table like this:

        WITH DATA AS (
          SELECT 45 AS user_id, '2023-07-15' AS date, true AS had_session
          UNION ALL
          SELECT 45, '2023-07-16', false
          UNION ALL
          SELECT 45, '2023-07-17', true
          UNION ALL
          SELECT 45, '2023-07-18', true
          UNION ALL
          SELECT 45, '2023-07-19', true
          UNION ALL
          SELECT 45, '2023-07-20', false
          UNION ALL
          SELECT 45, '2023-07-21', true
          UNION ALL
          SELECT 45, '2023-07-22', true
          UNION ALL
          SELECT 45, '2023-07-23', false
          UNION ALL
          SELECT 45, '2023-07-24', false
          UNION ALL
          SELECT 45, '2023-07-25', false
          UNION ALL
          SELECT 45, '2023-07-26', false
        )
        SELECT *,
               -- ordinal number subquery AS consequente_counter
          FROM DATA
      ORDER BY date

I want to add one more column which will contain ordinal numbers for true and false. The number will start from 1 whenever the value is changed compared to the value of the previous date. Due to requirements, this has to be done in standard SQL, without using cursors or stored procedures.

Example

Image of the results

Use below approach (BigQuery Standard SQL)

SELECT * EXCEPT(reset, grp), 
ROW_NUMBER() OVER(PARTITION BY user_id, grp ORDER BY date) AS consequente_counter
FROM (
SELECT *, COUNTIF(reset) OVER(PARTITION BY user_id ORDER BY date) grp
FROM (
SELECT *,
IFNULL(had_session != LAG(had_session) OVER(PARTITION BY user_id ORDER BY date), TRUE) reset 
FROM DATA
)
)
ORDER BY date

If applied to sample data in your question - output is