Identifiers starting with "not" inside PHQL strings are changed/suppressed

[marceloandrader]

Discussed in #15694

^{Originally posted by tobispace September 29, 2021}
Example query:

$notificationsManual = Notification::query()
	->andWhere( 'MyNs\Models\Application\Notification.Published = 1' )
	->andWhere( 'MyNs\Models\Application\Notification.Id NOT IN ( SELECT MyNs\Models\Application\NotificationLog.NotificationId FROM MyNs\Models\Application\NotificationLog WHERE MyNs\Models\Application\NotificationLog.Active = 1 )' )
	->andWhere( 'MyNs\Models\Application\Notification.DateToSend <= :today:', [ 'today' => date( 'Y-m-d' ) . ' 23:59:59' ] )
	->execute();

This query was working on Phalcon 3.4.4 (php 7.3)

When upgrading to Phalcon 4.1.2 (php 7.4), I get this error:

Column 'ificationId' doesn't belong to the model or alias 'SHL\Models\Application\Notification', when executing: 
SELECT [MyNs\Models\Application\Notification].* 
FROM [MyNs\Models\Application\Notification] WHERE ((MyNs\Models\Application\Notification.Published = 1) 
AND (MyNs\Models\Application\Notification.Id NOT IN ( SELECT MyNs\Models\Application\NotificationLog.NotificationId 
FROM MyNs\Models\Application\NotificationLog WHERE MyNs\Models\Application\NotificationLog.Active = 1 ))) 
AND (( MyNs\Models\Application\Notification.DateToSend <= :today: ))

This seems to happen with all PHQL queries where there is an identifier starting with "not" (case insensitive).

Why??

I'm too having issues with this in a current upgrade from phalcon 3.4 to 4.1, in my case the issue is with fields like notes_id or notes_type
Here is the smallest sample that PHQL parsing is removing the 'Not' part from the Notes table name:

[niden]

Duplicate of #14641