tests/testthat/_snaps/query-select.md

In dbplyr: A 'dplyr' Back End for Databases

select_query() print method output is as expected

Code
  mf
Output
  <SQL SELECT>
  From:
    <dbplyr_table_ident[1]>
    [1] `df`
  Select:   `df`.*
  Where:    `x` > 1
  Order by: `x`
  Limit:    10

queries generated by select() don't alias unnecessarily

Code
  lf_render
Output
  <SQL> SELECT `x`
  FROM `df`

Code
  lazy_frame(x = 1, y = 1) %>% select()
Condition
  Error in `sql_clause_select()`:
  ! Query contains no columns

dbplyr documentation built on Oct. 26, 2023, 9:06 a.m.