{"library":"mo-sql-parsing","title":"More SQL Parsing!","description":"mo-sql-parsing is a Python library designed to parse SQL queries into a JSON-izable parse tree. It aims to convert various SQL dialects, initially targeting MySQL, into a structured JSON format, making it easier to translate or analyze SQL for different datastores. As of version 11.697.25301, the library is actively maintained, with ongoing issue resolution and regular updates, as indicated by its high version number and recent activity on GitHub (October 2024 Project Status).","language":"python","status":"active","last_verified":"Thu Apr 16","install":{"commands":["pip install mo-sql-parsing"],"cli":null},"imports":["from mo_sql_parsing import parse","from mo_sql_parsing import parse_sqlserver","from mo_sql_parsing import parse_mysql"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"from mo_sql_parsing import parse\n\n# Basic SELECT query\nsql_query = \"select count(1) from jobs\"\nparsed_json = parse(sql_query)\nprint(f\"Parsed basic query: {parsed_json}\")\n# Expected: {'select': {'value': {'count': 1}}, 'from': 'jobs'}\n\n# SELECT with aliases\nsql_query_aliases = \"select a as hello, b as world from jobs\"\nparsed_json_aliases = parse(sql_query_aliases)\nprint(f\"Parsed query with aliases: {parsed_json_aliases}\")\n# Expected: {'select': [{'value': 'a', 'name': 'hello'}, {'value': 'b', 'name': 'world'}], 'from': 'jobs'}\n\n# Example with SQLServer-specific parsing\nfrom mo_sql_parsing import parse_sqlserver\nsqlserver_query = \"SELECT [Timestamp] FROM [table]\"\nparsed_sqlserver = parse_sqlserver(sqlserver_query)\nprint(f\"Parsed SQLServer query: {parsed_sqlserver}\")\n# Expected: {'select': 'Timestamp', 'from': 'table'}\n","lang":"python","description":"The `mo_sql_parsing` library's primary function is `parse`, which takes a SQL string and returns a JSON-like Python dictionary representing the parse tree. Specialized parsers like `parse_sqlserver` and `parse_mysql` are available for dialect-specific syntax.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}