sql.query

Perform a direct SQL query with minimal processing

A comprehensive data analysis framework for NIH-funded research that streamlines workflows for both data cleaning and preparing NIH Data Archive ('NDA') submission templates. Provides unified access to multiple data sources ('REDCap', 'MongoDB', 'Qualtrics') through interfaces to their APIs, with specialized functions for data cleaning, filtering, merging, and parsing. Features automatic validation, field harmonization, and memory-aware processing to enhance reproducibility in multi-site collaborative research as described in Mittal et al. (2021) <doi:10.20900/jpbs.20210011>.

Joshua G. Kenney

wizaRdry

A Magical Framework for Collaborative & Reproducible Data
Analysis

Trevor F. Williams

Minerva K. Pappu

Michael J. Spilka

Danielle N. Pratt 

Victor J. Pokorny

Santiago Castiello de Obeso

Praveen Suthaharan

Christian R. Horgan

sql.query function

<dl><dt>query</dt>
<dd>The SQL query to execute</dd>
<dt>pii</dt>
<dd>Logical; if FALSE (default), remove fields marked as PII. TRUE keeps PII.</dd></dl>

Arguments

Perform a direct SQL query with minimal processing — sql.query

<dl>

<dt>query</dt>
<dd>The SQL query to execute</dd>


<dt>pii</dt>
<dd>Logical; if FALSE (default), remove fields marked as PII. TRUE keeps PII.</dd>

</dl>

Perform a direct SQL query with minimal processing

sql.query: Perform a direct SQL query with minimal processing

Description

Usage

Value

Arguments