-
Centralized Error Detection: Added centralized error detection system with configurable patterns
- New
errors.yamlconfiguration file with error patterns - Supports three pattern types: fuzzy matches, exact matches, and regex matches
- Automatically detects errors in stdout and moves them to error field
- Eliminates need for external applications to parse error messages
- Includes patterns for HTTP 4xx/5xx errors, DNS failures, connection errors, and timeouts
- Added
ErrorDetectorclass for pattern-based error detection
- New
-
Markdown-KV Output Format: Added
markdownkvoutput format optimized for LLM understanding- Based on research showing 60.7% LLM accuracy vs 44.3% for CSV
- Ideal for RAG pipelines and AI-based systems processing tabular data
- Hierarchical structure with markdown headers and code blocks
- Supported in both local and server modes
- Reference: Which Table Format Do LLMs Understand Best?
- Added
PyYAML>=5.4.0for error pattern configuration
- Added comprehensive test suite for error detection (
tests/test_error_detection.py) - Added test suite for Markdown-KV format (
tests/test_markdownkv_format.py) - Tests for regex pattern matching, DNS errors, connection errors, and timeouts
- Tests for LLM-friendly data formatting
- Added
--csv-downloadargument for stackql magic commands - Refactor
- Enhanced test coverage
- Added
http_debugconstructor argument to return HTTP log information
- Fixed issue passing JSON strings to queries, added test
- Added support for setting command specific environment variables (
env_varsandcustom_auth) inexecuteandexecuteStmt. - Upgraded to use
psycopg
- Fix(MacOS): Enhanced platform check for stackql installation
- Fix(Test Code): Removed loading of
test.envin test execution script and Add mocking logic forpystackql.StackQL's methods.
- added dataflow dependency arguments
- build updates
- added
rowsaffectedto dict response forexecuteStmt
- modified dict response for
executeStmt - modified error response for
execute, should never returnNone
- added
suppress_errorsargument to theexecutefunction
- added
backend_storage_modeandbackend_file_storage_locationconstructor args for specifying a file based backend (not applicable inserver_mode)
- added
custom_registryconstructor arg for specifying a non-default registry
- included
pandasandIPythoninstall requirements - optional required import of
psycopg2only if inserver_mode
- included
app_rootandexecution_concurrency_limitoptions inStackQLconstructor
- implemented non
server_modemagic extension - updated dataframe output for statements
pandastype updates- updated class parameters
- added additional tests
- bin path defaults for codespaces notebooks
- added
StackqlMagicclass forjupyter,IPythonintegration server_modeis now used to connect to astackqlserver process usingpyscopg2- added additional tests
- added
executeQueriesAsyncstackql class method
- added
server_modeto run a background stackql server process
- enabled custom
download_dirargument
- updated
setup.py
- refactored package
- added support for
kwargsfor theStackQLconstructor - added
setup.py - added
docsusingsphinx - added additional tests
- added exception handling
- added local registry support
- updated docs
- added
strhandling - updated docs
- updated
versionoutput - updated docs
- added
authswitch - converted
byteoutput tostr
- added
versionmethod - updates to accept
Nonefor arguments - updated docs
- added
dbfilepathargument
- class constructor for
pyinfraql - support for
googleprovider - support for integration with
pandas,matplotlibandjupyter