{"id":27575,"library":"absql","title":"ABSQL","description":"A rendering engine for templated SQL. Current version 0.6.3, with occasional releases. Supports Jinja-like templating, YAML frontmatter, and multiple file types.","status":"active","version":"0.6.3","language":"python","source_language":"en","source_url":"https://github.com/pipeline-tools/ABSQL","tags":["sql","templating","jinja","yaml","rendering"],"install":[{"cmd":"pip install absql","lang":"bash","label":"PyPI"}],"dependencies":[],"imports":[{"wrong":"from absql import ABSQLEngine","symbol":"Runner","correct":"from absql import Runner"},{"symbol":"render","correct":"from absql import render"},{"symbol":"render_file","correct":"from absql import render_file"}],"quickstart":{"code":"from absql import ABSQLEngine\n\nengine = ABSQLEngine()\ntemplate = \"\"\"\n---\ndb: postgresql\n---\nSELECT * FROM {{ table_name }}\n\"\"\"\nresult = engine.render(template, table_name='users')\nprint(result)","lang":"python","description":"Define a template with YAML frontmatter and render with context variables."},"warnings":[{"fix":"If you relied on the old key (e.g., `result['sql']`), update to `result['absql_body']`.","message":"In v0.6.0, when `return_dict=True`, the key for file-specific content changed to `absql_body` instead of the filename.","severity":"breaking","affected_versions":">=0.6.0"},{"fix":"Install `flatdict` separately if needed: `pip install flatdict`.","message":"The `flatdict` package dependency was removed in v0.6.3. If you used `flatdict` directly in your code, it will break.","severity":"gotcha","affected_versions":">=0.6.3"}],"env_vars":null,"search_vec":"'0.6.3':10 'absql':1 'current':8 'engin':4 'file':23 'frontmatt':20 'jinja':16,27 'jinja-lik':15 'like':17 'multipl':22 'occasion':12 'releas':13 'render':3,29 'sql':7,25 'support':14 'templat':6,18,26 'type':24 'version':9 'yaml':19,28","created_at":"2026-05-09T05:50:57.692776+00:00","updated_at":"2026-05-09T05:50:57.692776+00:00","problems":null,"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":"","cli_version":null,"type":"library","homepage":null,"github":"https://github.com/pipeline-tools/ABSQL","docs":null,"changelog":null,"pypi":"https://pypi.org/project/absql/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["serialization","data","workflow","database","devops"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"passing","verified_at":"2026-07-03","last_verified":"2026-07-03","next_check":"2026-08-02","install_tag":null}}