#r "Strata.SqlUtilities/bin/Debug/net8.0/Strata.SqlUtilities.dll"
#r "Strata.SqlUtilities.SqlServer/bin/Debug/net8.0/Strata.SqlUtilities.SqlServer.dll"

using Strata.SqlUtilities.Breakdowns.SqlServer;
using Strata.SqlUtilities.Expressions;

var query = new QueryBreakdown();
var col = new GenericColumnExpression("Name", "Users");
var expr = col == "John";

query.AddWhereExpression(expr);

Console.WriteLine($"WhereClause.Clause: '{query.WhereClause.Clause}'");
Console.WriteLine($"Length: {query.WhereClause.Clause.Length}");
Console.WriteLine($"Contains 'John': {query.WhereClause.Clause.Contains("'John'")}");

// Print each character
for (int i = 0; i < query.WhereClause.Clause.Length; i++)
{
    Console.WriteLine($"[{i}]: '{query.WhereClause.Clause[i]}' (0x{((int)query.WhereClause.Clause[i]):X2})");
}