Retrieve joined data from the database

Source: R/db_tbl.R, R/fct_search.R

This function retrieves data by performing a series of INNER JOIN operations across multiple tables in the database, including lab_measurement, analyte, lab_sample, lab_field_sample, field_sample, sites, and species. The result is a combined dataset containing related information from all these tables.

get_db(con = NULL)

get_db(con = NULL)

Arguments

con

A DBI connection object. The database connection used to query the data.

Value

A lazy data frame (tibble) representing the joined data. The query is not executed until explicitly requested by the user (e.g., with dplyr::collect()).