A short but very cool article about the QueryTypes feature in EF Core (2.1 and newer).

Nothing beats handcrafted SQL query in terms of performance or feature availability from the database engine itself. And understanding, at least on a basic level, SQL and execution plans helps preventing performance issues with using ORM.