v0.5.0

TidierDB v0.5.0

Breaking Changes:

• All join syntax now matches TidierData's (table1, table2, t1_col = t2_col)

Additions:

• @computefor DuckDB, MySQL, PostGres, GBQ to write a table to the db at the end of a query.
• expands @create_view to MySQL, PostGres, GBQ
• Support for performing multiple joins of TidierDB queries in a single chain with further tests
• dmy, mdy, ymd support DuckDB, Postgres, GBQ, Clickhouse, MySQL, MsSQL, Athena, MsSQL
• support for working with intervals ie + interval4days - interval5months etc
• Date related tests
• copy_to for MysQL to write a dataframe to MySQL database
• 65 total tests matching TidierData to TidierDB results

Improvements:

• improve Google Big Query type mapping when collecting to dataframe
• change gbq()'s connect() to accept location as second argument
• str_detect now supports regex for all backends except MsSQL + some tests
• @select(!table.name) now works to deselect a column

Docs:

• Add duckplyr/duckdb reproducible example to docs
• Improve interpolation docs

Diff since v0.4.1

Merged pull requests:

• Catch a bug then write a test (#70) (@drizk1)
• add copy_to2 (#72) (@vituri)
• resolve GBQ and MySQL toml issues (#76) (@drizk1)
• Regex support for str detect (#77) (@drizk1)
• small improvment in filepath reading (#79) (@drizk1)

Closed issues:

• Functions to write to a database (#16)
• How can I write functions that pass arguments do TidierDB functions? (#20)
• Parsing Interpolation (#22)
• Add tests comparing tidierdata (#67)
• str_detect does not support regex (#74)
• recreated duckplyr/duckdb ex - add as docs? (#78)