# quoting for rendering ordered grouped table

    Code
      sql_render(out)
    Output
      <SQL> SELECT `test-verb-arrange`.*
      FROM `test-verb-arrange`
      ORDER BY `y`

# arrange renders correctly (#373)

    Code
      # # arrange renders correctly
      lf <- lazy_frame(a = 1:3, b = 3:1)
      # basic
      lf %>% arrange(a)
    Output
      <SQL>
      SELECT `df`.*
      FROM `df`
      ORDER BY `a`
    Code
      # double arrange
      lf %>% arrange(a) %>% arrange(b)
    Output
      <SQL>
      SELECT `df`.*
      FROM `df`
      ORDER BY `b`
    Code
      # remove ordered by
      lf %>% arrange(a) %>% select(-a)
    Output
      <SQL>
      SELECT `b`
      FROM `df`
      ORDER BY `a`
    Code
      lf %>% arrange(a) %>% select(-a) %>% arrange(b)
    Output
      <SQL>
      SELECT `b`
      FROM `df`
      ORDER BY `b`
    Code
      # un-arrange
      lf %>% arrange(a) %>% arrange()
    Output
      <SQL>
      SELECT `df`.*
      FROM `df`
    Code
      lf %>% arrange(a) %>% select(-a) %>% arrange()
    Output
      <SQL>
      SELECT `b`
      FROM `df`
    Code
      # use order
      lf %>% arrange(a) %>% select(-a) %>% mutate(c = lag(b))
    Output
      <SQL>
      SELECT `b`, LAG(`b`, 1, NULL) OVER () AS `c`
      FROM `df`
      ORDER BY `a`

# arrange renders correctly for single-table verbs (#373)

    Code
      lf <- lazy_frame(a = 1:3, b = 3:1)
      # head
      lf %>% head(1) %>% arrange(a)
    Output
      <SQL>
      SELECT `q01`.*
      FROM (
        SELECT `df`.*
        FROM `df`
        LIMIT 1
      ) AS `q01`
      ORDER BY `a`
    Code
      lf %>% arrange(a) %>% head(1)
    Output
      <SQL>
      SELECT `df`.*
      FROM `df`
      ORDER BY `a`
      LIMIT 1
    Code
      lf %>% arrange(a) %>% head(1) %>% arrange(b)
    Output
      <SQL>
      SELECT `q01`.*
      FROM (
        SELECT `df`.*
        FROM `df`
        ORDER BY `a`
        LIMIT 1
      ) AS `q01`
      ORDER BY `b`
    Code
      # mutate
      lf %>% mutate(a = b) %>% arrange(a)
    Output
      <SQL>
      SELECT `b` AS `a`, `b`
      FROM `df`
      ORDER BY `a`
    Code
      # complex mutate
      lf %>% arrange(a) %>% mutate(a = b) %>% arrange(a)
    Output
      <SQL>
      SELECT `b` AS `a`, `b`
      FROM `df`
      ORDER BY `a`
    Code
      lf %>% arrange(a) %>% mutate(a = 1) %>% arrange(b)
    Output
      <SQL>
      SELECT 1.0 AS `a`, `b`
      FROM `df`
      ORDER BY `b`
    Code
      lf %>% mutate(a = -a) %>% arrange(a) %>% mutate(a = -a)
    Condition
      Warning:
      ORDER BY is ignored in subqueries without LIMIT
      i Do you need to move arrange() later in the pipeline or use window_order() instead?
    Output
      <SQL>
      SELECT -`a` AS `a`, `b`
      FROM (
        SELECT -`a` AS `a`, `b`
        FROM `df`
      ) AS `q01`

# can combine arrange with dual table verbs

    Code
      lf <- lazy_frame(a = 1:3, b = 3:1)
      rf <- lazy_frame(a = 1:3, c = 4:6)
      # warn if arrange before join
      lf %>% arrange(a) %>% left_join(rf)
    Message
      Joining with `by = join_by(a)`
    Condition
      Warning:
      ORDER BY is ignored in subqueries without LIMIT
      i Do you need to move arrange() later in the pipeline or use window_order() instead?
    Output
      <SQL>
      SELECT `LHS`.*, `c`
      FROM (
        SELECT `df`.*
        FROM `df`
      ) AS `LHS`
      LEFT JOIN `df`
        ON (`LHS`.`a` = `df`.`a`)
    Code
      lf %>% arrange(a) %>% semi_join(rf)
    Message
      Joining with `by = join_by(a)`
    Condition
      Warning:
      ORDER BY is ignored in subqueries without LIMIT
      i Do you need to move arrange() later in the pipeline or use window_order() instead?
    Output
      <SQL>
      SELECT `LHS`.*
      FROM (
        SELECT `df`.*
        FROM `df`
      ) AS `LHS`
      WHERE EXISTS (
        SELECT 1 FROM `df`
        WHERE (`LHS`.`a` = `df`.`a`)
      )
    Code
      lf %>% arrange(a) %>% union(rf)
    Output
      <SQL>
      SELECT `df`.*, NULL AS `c`
      FROM `df`
      ORDER BY `a`
      
      UNION
      
      SELECT `a`, NULL AS `b`, `c`
      FROM `df`
    Code
      # can arrange after join
      lf %>% left_join(rf) %>% arrange(a)
    Message
      Joining with `by = join_by(a)`
    Output
      <SQL>
      SELECT `q01`.*
      FROM (
        SELECT `df_LHS`.*, `c`
        FROM `df` AS `df_LHS`
        LEFT JOIN `df` AS `df_RHS`
          ON (`df_LHS`.`a` = `df_RHS`.`a`)
      ) AS `q01`
      ORDER BY `a`
    Code
      lf %>% semi_join(rf) %>% arrange(a)
    Message
      Joining with `by = join_by(a)`
    Output
      <SQL>
      SELECT `q01`.*
      FROM (
        SELECT `df_LHS`.*
        FROM `df` AS `df_LHS`
        WHERE EXISTS (
          SELECT 1 FROM `df` AS `df_RHS`
          WHERE (`df_LHS`.`a` = `df_RHS`.`a`)
        )
      ) AS `q01`
      ORDER BY `a`
    Code
      lf %>% union(rf) %>% arrange(a)
    Output
      <SQL>
      SELECT `q01`.*
      FROM (
        SELECT `df`.*, NULL AS `c`
        FROM `df`
      
        UNION
      
        SELECT `a`, NULL AS `b`, `c`
        FROM `df`
      ) AS `q01`
      ORDER BY `a`