An abstract R6 class defining the interface that custom QueryChat data
sources must implement. This class should not be instantiated directly;
instead, use one of its concrete implementations like DataFrameSource or
DBISource.
Public fields
table_nameName of the table to be used in SQL queries
Methods
Method get_db_type()
Get the database type
Returns
A string describing the database type (e.g., "DuckDB", "SQLite")
Method get_schema()
Get schema information about the table
Usage
DataSource$get_schema(categorical_threshold = 20)
Arguments
categorical_thresholdMaximum number of unique values for a text
column to be considered categorical
Returns
A string containing schema information formatted for LLM prompts
Method execute_query()
Execute a SQL query and return results
Usage
DataSource$execute_query(query)
Arguments
querySQL query string to execute
Returns
A data frame containing query results
Method test_query()
Test a SQL query by fetching only one row
Usage
DataSource$test_query(query)
Arguments
querySQL query string to test
Returns
A data frame containing one row of results (or empty if no matches)
Method get_data()
Get the unfiltered data as a data frame
Returns
A data frame containing all data from the table
Method cleanup()
Clean up resources (close connections, etc.)
Method clone()
The objects of this class are cloneable with this method.
Usage
DataSource$clone(deep = FALSE)
Arguments
deepWhether to make a deep clone.
