{"repo":"sidequery/poached","free":true,"listed":false,"github":"https://github.com/sidequery/poached","clone":"git clone https://github.com/sidequery/poached.git","description":"A DuckDB extension that exposes SQL parsing functionality for building IDEs, SQL editors, query analyzers, and other developer tools.","language":"C++","stars":11,"topics":["duckdb","duckdb-extension"],"license":"MIT","category":"databases-storage","readme_excerpt":"poached A DuckDB extension that exposes SQL parsing functionality for building IDEs, SQL editors, query analyzers, and other developer tools. Features API shape: parse returns detailed rows (table functions), while parse names returns names-only lists (scalars). Tokenization Function Kind Returns Description Deprecated alias of --- --- --- --- --- parse tokens(query) table byte position bigint, category varchar Returns tokens with byte positions and categories (KEYWORD, IDENTIFIER, OPERATOR, NUMERIC CONSTANT, STRING CONSTANT). Uses DuckDB's internal tokenizer for accurate syntax highlighting. Note: comments are stripped before tokenization. - tokenize sql(query) table byte position bigint, category varchar Deprecated alias. parse tokens Statement Analysis Function Kind Returns Description Deprecated alias of --- --- --- --- --- parse statements(query) table stmt index bigint, stmt type varchar, error varchar, param count bigint Parse multi-statement SQL, returns statement type and errors. - num statements(query) scalar bigint Count statements in a query. - is valid sql(query) scalar boolean Check if SQL is syntactically valid. - sql error message(query) scalar varchar (nullable) Get parse error message (NULL if valid). - Schema Introspection Function Kind Returns Description Deprecated alias of --- --- --- --- --- parse columns(query, stmt index) table col index bigint, col name varchar Get result column names from SELECT list. - parse column names(query, stmt index) scalar l","default_branch":null,"files":null,"tree":[],"storefront":"/r/sidequery","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/sidequery/poached/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}