Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.Tests\bin\Debug\net8.0\Strata.SqlTools.Tests.dll (.NETCoreApp,Version=v8.0)
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.Markdown.Tests\bin\Debug\net8.0\Strata.SqlTools.Markdown.Tests.dll (.NETCoreApp,Version=v8.0)
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.Rules.Tests\bin\Debug\net8.0\Strata.SqlTools.Rules.Tests.dll (.NETCoreApp,Version=v8.0)
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.PostgreSql.Tests\bin\Debug\net8.0\Strata.SqlTools.PostgreSql.Tests.dll (.NETCoreApp,Version=v8.0)
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.EFCore.Tests\bin\Debug\net8.0\Strata.SqlTools.EFCore.Tests.dll (.NETCoreApp,Version=v8.0)
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.Snowflake.Tests\bin\Debug\net8.0\Strata.SqlTools.Snowflake.Tests.dll (.NETCoreApp,Version=v8.0)
Test run for C:\Git\sql-utilities\tests\Strata.SqlTools.SqlServer.Tests\bin\Debug\net8.0\Strata.SqlTools.SqlServer.Tests.dll (.NETCoreApp,Version=v8.0)
VSTest version 17.14.1 (x64)

VSTest version 17.14.1 (x64)

VSTest version 17.14.1 (x64)
VSTest version 17.14.1 (x64)

VSTest version 17.14.1 (x64)
VSTest version 17.14.1 (x64)



VSTest version 17.14.1 (x64)

Starting test execution, please wait...
Starting test execution, please wait...
A total of 1 test files matched the specified pattern.
Starting test execution, please wait...
Starting test execution, please wait...
Starting test execution, please wait...
Starting test execution, please wait...
Starting test execution, please wait...
A total of 1 test files matched the specified pattern.
A total of 1 test files matched the specified pattern.
A total of 1 test files matched the specified pattern.
A total of 1 test files matched the specified pattern.
A total of 1 test files matched the specified pattern.
A total of 1 test files matched the specified pattern.

Passed!  - Failed:     0, Passed:    90, Skipped:     0, Total:    90, Duration: 95 ms - Strata.SqlTools.Tests.dll (net8.0)
Regenerated Snowflake SQL:
SELECT
    -- Primary key -- Customer name field /* Email address for notifications */
    ID,

NAME, 



EMAIL,

STATUS
FROM
    -- Main user table
    USERS
WHERE
    /* Filter for active users only */
    STATUS = 'Active'
ORDER BY
    -- Sort alphabetically
    NAME


Regenerated SQL:


SELECT 
     -- Primary key -- Customer name field /* Email address for notifications */
     ID,

Name, 



Email,

Status
FROM 
     -- Main user table
     Users
WHERE 
     /* Filter for active users only */
     Status = 'Active'
ORDER BY 
     -- Sort alphabetically
     Name




  Skipped AllQueriesDirectory_Exists [4 ms]
  Skipped GenerateMarkdownForAllQueries_CreatesMarkdownFiles [4 ms]
  Skipped GenerateMarkdownForAllQueries_IncludesQuerySource [4 ms]
  Skipped OutputDirectory_IsCreated [4 ms]


Passed!  - Failed:     0, Passed:    90, Skipped:     4, Total:    94, Duration: 154 ms - Strata.SqlTools.Markdown.Tests.dll (net8.0)
Passed!  - Failed:     0, Passed:    78, Skipped:     0, Total:    78, Duration: 110 ms - Strata.SqlTools.PostgreSql.Tests.dll (net8.0)
((1 + 2) <= 50)

input => input.DepartmentCode.StartsWith("01", OrdinalIgnoreCase)

input => input.DepartmentCode.StartsWith("012C", OrdinalIgnoreCase)

input => input.DepartmentCode.StartsWith("012c", OrdinalIgnoreCase)

input => input.DepartmentCode.StartsWith("oasd", OrdinalIgnoreCase)

101 == 103 || 120 > 119 || input.TotalCharges > 200.0 && input.DepartmentName == "foobar"

items => items.Any(s => (s.Length >= 4))
input.DepartmentId == 3 && input.PatientId == 5 && input.Details.Any(p => p.CPTCode == "123")

input.Details.Any(p => p.CPTCode == "123" && p.UBRevCode == "0999")



Passed!  - Failed:     0, Passed:   161, Skipped:     0, Total:   161, Duration: 176 msPassed!  - Failed:     0, Passed:   217, Skipped:     0, Total:   217, Duration: 152 ms - Strata.SqlTools.Snowflake.Tests.dll (net8.0)
 - Strata.SqlTools.SqlServer.Tests.dll (net8.0)

Passed!  - Failed:     0, Passed:    69, Skipped:     0, Total:    69, Duration: 287 ms - Strata.SqlTools.Rules.Tests.dll (net8.0)

Passed!  - Failed:     0, Passed:    15, Skipped:     0, Total:    15, Duration: 675 ms - Strata.SqlTools.EFCore.Tests.dll (net8.0)