NEWS

---

sqlcaser 0.2.1 (2025-09-09)

• Added support for different quote types and NULL handling strategies
• Implemented flexible column selection by name or index
• File validation - check if files exist before reading
• Input type validation - Ensure inputs are data frames or valid file paths
• Data validation - Check for empty data, sufficient columns, valid column names
• NA handling - Skip rows with NA values and warn users
• SQL injection protection - Escape single quotes in string values
• Better error messages - More descriptive error messages for troubleshooting
• Graceful degradation - Continue processing when possible, skip problematic row

sqlcaser 0.2.0 (2023-11-24)

• New function! updatetable() creates a SQL UPDATE...SET...WHERE query from a CSV file or dataframe that includes the values to be updated in the SQL table.

sqlcaser 0.1.3

• New function! inlist() creates a SQL IN() list from a CSV file or dataframe that includes the values to check for.

sqlcaser 0.1.2

• Added header argument to specify if input file has a header row.
• Added error message for unspecified inputs.

sqlcaser 0.1.1

• Added functionality to read in dataframes in addition to file paths.

sqlcaser 0.1.0

Initial Release to GitHub

• Initial Release to GitHub