Are SQL window functions performance efficient?

It really depends on their implementation in the specific RDBMS you are using, but in Oracle, which is the database system I use the most, they are very efficient.

Usually you can solve complex problems easily and more efficiently than if you used some other method (provided that you use them correctly).