```cs
var criteria = new
{
    Names = new[] { "John", "Piter" },
    DepartmentId = 100 as int?,
    IncludeDepartment = true,
};

string sql = $@"
SELECT
    {@if(criteria.IncludeDepartment, @"
        dep.Id,
        dep.Name,"
    )}
    emp.Id,
    emp.Name,
FROM dbo.Emloyees AS emp
{@if(criteria.IncludeDepartment, @"
    LEFT JOIN Departments AS dep ON dep.Id = emp.DepartmentId"
)}
WHERE
{@if(criteria.DepartmentId != null, @"
    emp.DepartmentId = @DepartmentId",
@else(@"
    emp.DepartmentId IS NULL"
))}
AND (
{@foreach(criteria.Names, name =>
    $"emp.Name LIKE '{name}%'",
    " OR "
)})";
```