You cannot change the way the compiler interprets query statements. These are referred to as query comprehensions - and the rules for translating these are built directly into the C# compiler. Every query is translated into an appropriate sequence of calls to into the extensions methods within the Linq library.
If you use tools like Reflector, you will see the corresponding sequence of extension method calls that such expressions are translated into.
The rules for query comprehensions are fully documented in the C# 3.0 specification.
While I agree that there are some specific cases where it might be useful to extend the query syntax in the language, I suspect that it requires a significant amount of sophisticated compile-time processing to convert them into appropriate function call syntax. I don't think that in most cases it would be easy to just inject processing for special cases without affecting how the entire expression is transformed.
In the meantime, realize that you can use chaining and regular extensions methods to expand on the capabilities of Linq.