v0.7.1

TidierDB v0.7.1

Diff since v0.7.0

• Queries print with key words in color by default (optional)
• db_table now supports Google Sheets links

db = connect(duckdb())
ghseet_connect(db) # authenticate in browser
gsheet = DB.db_table(db, "https://docs.google.com/spreadsheets/d/rest/of/link")

• add default support for the following window functions
  • lead, lag, dense_rank, nth_value, ntile, rank_dense, row_number, first_value, last_value, cume_dist
• add ability to add additional aggregate functions to reduce avoid excessive use of agg
  • push!(TidierDB.window_agg_fxns, :kurtosis);
  • push!(TidierDB.window_agg_fxns, :regr_slope);
• bug fix when using agg() with window ordering and framing
• fixes edge case query construction issues with @mutate,@filter,@*_join (thanks to @rgreminger for catching them!)
• fixes edge case with @select call after group_by -> summarize

Merged pull requests:

• Bump coverallsapp/github-action from 2.3.4 to 2.3.6 (#101) (@dependabot[bot])
• Agg window fix (#103) (@drizk1)
• Join mutate namebug (#105) (@drizk1)
• print in color! (#106) (@drizk1)
• add google sheet support to db_table (#107) (@drizk1)

Closed issues:

• Add duckdb google sheets support (#80)
• @arrange does not do anything after @group_by (#102)
• @select after @group_by produces error (#104)