{"id":20898,"library":"acryl-sqlglot","title":"SQLGlot","description":"SQLGlot is a no-dependency SQL parser, transpiler, and optimizer written in Python. It can parse a wide variety of SQL dialects, transpile between them, and produce formatted SQL. Current version is 25.25.2.dev9 (development release; stable releases follow semantic versioning and are frequent).","status":"active","version":"25.25.2.dev9","language":"python","source_language":"en","source_url":"https://github.com/tobymao/sqlglot","tags":["sql","parser","transpiler","formatter"],"install":[{"cmd":"pip install acryl-sqlglot","lang":"bash","label":"Install"}],"dependencies":[],"imports":[{"wrong":"from sqlglot import parse_one","symbol":"parse_one","correct":"from sqlglot import parse_one"}],"quickstart":{"code":"import sqlglot\n\n# Parse and transpile SQL\nresult = sqlglot.transpile(\"SELECT * FROM table\", read='mysql', write='postgres')\nprint(result[0])  # Output: SELECT * FROM \"table\"\n\n# Pretty print\npretty = sqlglot.transpile(\"SELECT a,b FROM foo\", pretty=True)\nprint(pretty[0])","lang":"python","description":"Parse SQL, transpile between dialects, and format."},"warnings":[{"fix":"Use 'import sqlglot' or 'from sqlglot import ...'.","message":"Import from 'sqlglot', NOT 'acryl_sqlglot'. The PyPI package is 'acryl-sqlglot' but the Python module is 'sqlglot'.","severity":"gotcha","affected_versions":"all"},{"fix":"Use dialect classes like sqlglot.dialects.mysql.MySQL.","message":"In older versions (pre-10.0), the dialect API was different. The 'dialect' argument in parse_one was replaced with explicit dialect classes.","severity":"breaking","affected_versions":"<10.0"}],"env_vars":null,"search_vec":"'25.25.2':35 'current':32 'depend':7 'dev9':36 'develop':37 'dialect':24 'follow':41 'format':30 'formatt':50 'frequent':46 'no-depend':5 'optim':12 'pars':18 'parser':9,48 'produc':29 'python':15 'releas':38,40 'semant':42 'sql':8,23,31,47 'sqlglot':1,2 'stabl':39 'transpil':10,25,49 'varieti':21 'version':33,43 'wide':20 'written':13","created_at":"2026-04-27T16:57:00.835920+00:00","updated_at":"2026-04-27T16:57:00.835920+00:00","problems":{"verify_error":"Traceback (most recent call last):\n  File \"<string>\", line 1, in <module>\n  File \"/tmp/tmp9hqq2f6v/venv/lib/python3.12/site-packages/sqlglot/__init__.py\", line 13, in <module>\n    from sqlglot import expressions as exp\n  File \"/tmp/tmp9hqq2f6v/venv/lib/python3.12/site-packages/sqlglot/expressions.py"},"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":"25.25.2.dev9","cli_name":"","cli_version":null,"type":"library","homepage":null,"github":"https://github.com/tobymao/sqlglot","docs":null,"changelog":null,"pypi":"https://pypi.org/project/acryl-sqlglot/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["data","serialization"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"import_fail","verified_at":"2026-07-03","last_verified":"2026-07-03","next_check":"2026-07-10","install_tag":null}}