tests/testthat/_snaps/query-select.md

In tidyverse/dbplyr: A 'dplyr' Back End for Databases

select_query() print method output is as expected

Code
  mf
Output
  <SQL SELECT>
  From:
    <table_path> `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

tidyverse/dbplyr documentation built on Dec. 5, 2024, 6:31 a.m.