It seems to me that the "ALL ROWS" keyword that you use in SOQL (to access records in the recycled bin) can only be used in Apex.
I went to Developer Console in the Query Editor and tried typing this
SELECT ID FROM Fruit__c
and it executes.
But If I add "ALL ROWS" at the end, i.e.
SELECT ID FROM Fruit__c ALL ROWS
then I got
"Unknown error parsing query" error.
If I write this in an Apex code, like this
List<Fruit__c> fruits = [SELECT ID FROM Fruit__c ALL ROWS];
then the line actually executes successfully.
It seems weird to me that "ALL ROWS" keyword cannot be used inside the Query Editor. Wondering if anyone has encountered that?