What is query performance and generated SQL in Entity Framework Core?

EF Core translates LINQ expressions into provider-specific SQL that should be inspected for important workloads.