knex_dart_snowflake 0.1.0

Snowflake driver for knex_dart — execute queries against Snowflake via the Snowflake SQL API v2 using the knex_dart query builder.

knex_dart_snowflake

Snowflake driver for knex_dart using the Snowflake SQL API v2.

Installation

dependencies:
  knex_dart_snowflake: ^0.1.0

Quick Start

import 'package:knex_dart_snowflake/knex_dart_snowflake.dart';

final db = KnexSnowflake(
  account: 'myorg-myaccount',
  token: 'oauth_or_jwt_token',
  database: 'MY_DATABASE',
  schema: 'PUBLIC',
  warehouse: 'COMPUTE_WH',
);

final rows = await db.select(
  db.queryBuilder().table('SALES').where('REGION', '=', 'EMEA').limit(25),
);

db.close();

Platform Requirements

• Works on Dart VM and web runtimes (HTTP-based driver).
• Requires Snowflake OAuth or JWT bearer token authentication.

Dialect Capabilities

Based on knex_dart_capabilities (snowflake dialect):

Capability	Support
returning	No
fullOuterJoin	Yes
lateralJoin	Yes
onConflictMerge	No
cte	Yes
windowFunctions	Yes
json	Yes
intersectExcept	Yes

Known Limitations

• No transaction helper in this driver.
• With asyncExecution: true, query methods return immediately and async results must be polled via getAsyncResult(statementHandle).
• Binding type conversion is limited to boolean/integer/real/text mapping.
• Result values are returned as Snowflake API payload values (commonly string-typed).