{"library":"pypika","type":"library","category":null,"description":"PyPika is a SQL query builder API for Python, allowing users to construct SQL queries programmatically. It supports various SQL dialects like PostgreSQL, MySQL, Oracle, and Redshift, and even JQL. The library is actively maintained, with frequent patch and minor releases, currently at version 0.51.1.","language":"python","status":"active","version":"0.51.1","tags":["sql","query builder","database","orm"],"install":[{"cmd":"pip install pypika","imports":["from pypika import Query","from pypika import Table","from pypika import Field","from pypika import functions as fn","from pypika.postgres import PostgreSQLQuery"]}],"homepage":null,"github":"https://github.com/kayak/pypika","docs":null,"changelog":null,"pypi":"https://pypi.org/project/pypika/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":1.6,"avg_import_s":0.08,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/pypika/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sun Jun 28","last_verified":"Sun Jun 28","next_check":"Tue Jul 28","install_tag":null}}