to_view,ANY-method

Provides an R6-based project container for managing 'DuckDB'
connections, reconnecting lazy database tables after session restarts, and
storing metadata for database-backed objects used by packages in the
'dbverse'. The package supplies S4 base classes and generics for
database-backed data, helpers for validating 'DuckDB' connections and table
names, utilities for creating persistent database views, and methods for
writing and restoring pinned lazy tables through the 'pins' package. These
tools help package authors and analysts keep database paths, cached
connections, and table references synchronized across interactive sessions
and project directories.

Edward C. Ruiz

dbProject

Database Connection Management and Utilities for 'dbverse'

Jiaji George Chen

Ruben Dries

to_view,ANY-method function

<dl><dt>x</dt>
<dd><code>tbl_sql</code>
Required. <code>tbl_sql</code> object to convert to a VIEW.</dd>
<dt>name</dt>
<dd><code>character</code>
Required. Name to assign VIEW within database. Auto-generated if none
provided with prefix <code>"tmp_view_"</code></dd>
<dt>temporary</dt>
<dd><code>logical</code>
If <code>TRUE</code> (default), the VIEW will not be saved in the database</dd>
<dt>overwrite</dt>
<dd><code>logical</code>
If <code>TRUE</code> (default), the VIEW will overwrite an existing VIEW of the same name</dd>
<dt>...</dt>
<dd>Additional arguments passed to <code><a href="https://dbi.r-dbi.org/reference/dbExecute.html">DBI::dbExecute()</a></code></dd></dl>

Arguments

Convert lazy table to named VIEW — to_view,ANY-method

<dl>

<dt>x</dt>
<dd><code>tbl_sql</code>
Required. <code>tbl_sql</code> object to convert to a VIEW.</dd>


<dt>name</dt>
<dd><code>character</code>
Required. Name to assign VIEW within database. Auto-generated if none
provided with prefix <code>"tmp_view_"</code></dd>


<dt>temporary</dt>
<dd><code>logical</code>
If <code>TRUE</code> (default), the VIEW will not be saved in the database</dd>


<dt>overwrite</dt>
<dd><code>logical</code>
If <code>TRUE</code> (default), the VIEW will overwrite an existing VIEW of the same name</dd>


<dt>...</dt>
<dd>Additional arguments passed to <code><a href='https://dbi.r-dbi.org/reference/dbExecute.html'>DBI::dbExecute()</a></code></dd>

</dl>

to_view,ANY-method: Convert lazy table to named VIEW

Description

Usage

Arguments