IssueTracker

Component used: Room
Version used: 2.7.0-alpha12
Devices/Android versions reproduced on: 7.6 Fold-in with outer display. Android API 34.

DESCRIBE THE ISSUE IN DETAIL:
The issue is very similar to https://issuetracker.google.com/issues/378896402. Long story short, in that issue, there was a problem with using window functions in queries. When trying to use window functions, a style check error arose: <compound operator>, FROM, GROUP, LIMIT, ORDER, WHERE or comma expected, got '('.

In this issue, the problem is not with window functions, but with dropping a column, specifically ALTER TABLE ... DROP COLUMN .... A style check error then appears on DROP saying: '.', ADD or RENAME expected, got 'DROP'.

The query itself runs fine, so the issue is only when trying to parse the query. In the similar issue, the grammar of Android Studio simply needed to be updated. I think something similar has to happen now again.

STEPS TO REPRODUCE:

1. Create a databate and table as usual.
2. In your DAO class, make a query

@Query("ALTER TABLE ... DROP COLUMN ...")
void dropQuery();

On DROP, you will see a message '.', ADD or RENAME expected, got 'DROP'. I also attached an image of this.

Studio Build: Ladybug | 2024.2.1 Patch 3
Version of Gradle Plugin: 8.2.0
Version of Gradle: 8.8
Version of Java: 18
OS: Windows 11