v0.3.4

TidierDB v0.3.4

Diff since v0.3.3

• TidierDB works with nearly any existing SQL function, now there are docs about it.
• Docs on using any existing SQL function in TidierDB
• Docs on user defined functions (UDFs) in TidierDB
• Adds agg() to allow use of any aggregate function built into a database to be used in @mutate. Support for agg() in across. (@summarize continues to all aggregate SQL functions without agg())
• Adds t(query) as a more efficient alternative to reference tables.

table = db_table(db, "table_name")
@chain t(table) ... 

• Bugfix: fixes MsSQL joins
• Bugfix: window functions
• Bugfix: json paths supported for json DuckDB functions

Merged pull requests:

• UDF docs, intro agg(), `t(), fix windows (#61) (@drizk1)
• fixes mssql joins (#62) (@drizk1)
• add upstream changes (#63) (@drizk1)

v0.3.3

TidierDB v0.3.3

Diff since v0.3.2

• Bugfix: @mutate allows type conversions as part of larger mutate expressions for all backends

Merged pull requests:

• fix type casting as part of larger mutation (#59) (@drizk1)

Closed issues:

• Support CrateDB (#57)
• connecting to SQL server (#58)

v0.3.2

TidierDB v0.3.2

Diff since v0.3.1

Adds

• @head for limiting number of collected rows
• support for reading URLS in db_table with ClickHouse
• support for reading from multiple files at once as a vector of urls in db_table when using ClickHouse
  • ie db_table(db, ["url1", "url2"])
• connect() support for MS SQL
• show_tables for most backends to view existing tables on connection

Bug Fixes

• Bugfix: @count updates metadata
• Bugfix: update_con can be part of chain (useful for expiring Snowflake tokens)
• Bugfix to allow CrateDB and RisingWave backends via LibPQ

Docs

• Docs comparing TidierDB to Ibis
• Docs around using * for reading in multiple files from folder
• Docs for db_table
• Docs for previewing or saving intermediate tables in ongoing @chain

Merged pull requests:

• add larger than ram ex (#50) (@drizk1)
• Add head aka limit (#52) (@drizk1)
• allows url and vectors of paths for CH (#53) (@drizk1)
• Improve ch (#54) (@drizk1)
• adds ibis comparison docs, fixes update_con so that it can be chained (#55) (@drizk1)
• Add show tables (#56) (@drizk1)

Closed issues:

• Clarify docs and maybe refine example for larger than mem with duckdb (#51)

v0.3.1

TidierDB v0.3.1

Diff since v0.3.0

• adds support for reading from multiple files at once as a vector of paths in db_table when using DuckDB
  • ie db_table(db, ["path1", "path2"])
• adds streaming support when using DuckDB with @collect(stream = true)
• allows user to customize file reading via db_table(db, "read_*(path, args)") when using DuckDB

Merged pull requests:

• Add streaming, multiple file reading and customized file reading with DuckDB backend (#49) (@drizk1)

Closed issues:

• Add streaming support for duckdb (#47)
• Add multiple file reading support (#48)

v0.3.0

TidierDB v0.3.0

Diff since v0.2.4

• Introduces package extensions for:
  • Postgres, ClickHouse, MySQL, MsSQL, SQLite, Oracle, Athena, and Google BigQuery
  • Documentation updated for using these backends.
• Change set_sql_mode() to use types not symbols (ie set_sql_mode(snowflake()) not set_sql_mode(:snowflake))

Merged pull requests:

• Remove Documenter from main dependencies of the package (#42) (@giordano)
• Some improvements to CI setup (#43) (@giordano)
• Delete and ignore .DS_Store (#44) (@giordano)
• Moves to use of package extensions. (#46) (@drizk1)

Closed issues:

• Compilation troubles with libpq (#23)
• Documenter is a useless dependency (#40)
• Using package extensions instead of requiring all backends (#45)

v0.2.4

TidierDB v0.2.4

Diff since v0.2.3

• Switches to DuckDB to 1.0 version
• Adds support for iceberg tables via DuckDB to read iceberg paths in db_table when iceberg = true
• Adds support for DuckDB's beta delta_scan to read delta paths in db_table when delta = true
• DuckDB MotherDucDB: connect(:duckdb, "token") // reconnect connect(:duckdb, "md:")

Merged pull requests:

• Add iceberg support (#39) (@drizk1)

v0.2.3

TidierDB v0.2.3

Diff since v0.2.2

• Adds direct path support for db_table when using DuckDB eliminating need to copy into local db
• Adds connect ability for AWS and Google Cloud to allow querying via S3 + DuckDB
• Adds documentation for S3 + DuckDB with TidierDB

Merged pull requests:

• adds s3 support w duckdb, improves db_table (#38) (@drizk1)

Closed issues:

• Snowflake (#5)

v0.2.2

TidierDB v0.2.2

Diff since v0.2.1

• adds support for Databricks backend for querying and connect
• adds documentation for connecting and using databricks
• fixes type conversion issue when collecting to dataframe from Snowflake

Merged pull requests:

• add databricks support (#36) (@drizk1)

Closed issues:

• Snowflake to dataframe makes all numbers float (#33)
• Add Databricks backend (#34)

v0.2.1

TidierDB v0.2.1

Diff since v0.2.0

• @collect bug fix

v0.2.0

TidierDB v0.2.0

Diff since v0.1.9

• Makes TidierDB case insensitive when using Snowflake, which is case insensitive

Merged pull requests:

• fix case sensitivity issue with snowflake vs tidierdb metadata (#32) (@drizk1)

Closed issues:

• Snowflake is case insensitive but TidierDB metadata is case sensitive (#31)