using SqlKata;

using SqlKata.Compilers;

using System;

using System.Collections.Generic;

​

class Program

{

    static void Main()

    {

        var sql = new Query("domains")

            .Select("domains.*")

            .SelectRaw("organizations.public_id")

            .Join("organizations", "organizations.id", "domains.organization_id")

            .WhereIn("organizations.public_id", new List<Guid>(){ Guid.Parse("00000000-0000-0000-0000-000000000000") });

​

    // Use a compiler (e.g., for SQL Server)

    var compiler = new PostgresCompiler();

    var sql = compiler.Compile(query).ToString();

​

    Console.WriteLine(sql);  // Prints the generated SQL query

    }

}

​

​