prql-dotnet

prql-net offers PRQL bindings for .NET bindings as a netstandard2.0 library.

It provides the PrqlCompiler class which contains the ToJson and ToSql static methods.

It’s still at an early stage, and isn’t published to NuGet. Contributions are welcome.

Installation

Make sure that libprql_lib.so (Linux), libprql_lib.dylib (macOS) or libprql_lib.dll (Windows) is in your project’s bin directory together with PrqlCompiler.dll and the rest of your project’s compiled files. I.e. {your_project}/bin/Debug/net7.0/.

The libprql_lib library gets dynamically imported at runtime.

Usage

  1. using Prql.Compiler;
  2. var options = new PrqlCompilerOptions
  3. {
  4. Format = false,
  5. SignatureComment = false,
  6. };
  7. var sql = PrqlCompiler.Compile("from employees", options);
  8. Console.WriteLine(sql);

TODO

This is currently at 0.1.0 because we’re waiting to update prql-lib for the latest API. When we’ve done that, we can match the version here with the broader PRQL version.