{"id":12643611,"name":"plpgsql-parser","ecosystem":"npm","description":"Combined SQL + PL/pgSQL parser with hydrated ASTs and transform API","homepage":"https://github.com/constructive-io/pgsql-parser","licenses":"MIT","normalized_licenses":["MIT"],"repository_url":"https://github.com/constructive-io/pgsql-parser","keywords_array":["sql","postgres","postgresql","pg","plpgsql","query","ast","parser","deparser","transform","database"],"namespace":null,"versions_count":22,"first_release_published_at":"2025-12-31T23:40:10.699Z","latest_release_published_at":"2026-05-09T16:05:58.920Z","latest_release_number":"0.5.9","last_synced_at":"2026-05-15T22:05:02.241Z","created_at":"2025-12-31T23:45:11.759Z","updated_at":"2026-05-15T22:05:02.241Z","registry_url":"https://www.npmjs.com/package/plpgsql-parser","install_command":"npm install plpgsql-parser","documentation_url":null,"metadata":{"funding":null,"dist-tags":{"latest":"0.5.9"}},"repo_metadata":{"id":39985479,"uuid":"272918231","full_name":"constructive-io/pgsql-parser","owner":"constructive-io","description":"🐘 PostgreSQL Query Parser for Node.js","archived":false,"fork":false,"pushed_at":"2026-04-15T03:44:32.000Z","size":29517,"stargazers_count":226,"open_issues_count":22,"forks_count":32,"subscribers_count":2,"default_branch":"main","last_synced_at":"2026-04-25T22:08:15.056Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"","language":"TypeScript","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"mit","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/constructive-io.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null,"notice":null,"maintainers":null,"copyright":null,"agents":null,"dco":null,"cla":null}},"created_at":"2020-06-17T08:22:08.000Z","updated_at":"2026-04-22T14:14:39.000Z","dependencies_parsed_at":"2023-12-16T00:01:13.962Z","dependency_job_id":"68de83db-e352-438d-abc6-d18a2d23f667","html_url":"https://github.com/constructive-io/pgsql-parser","commit_stats":{"total_commits":459,"total_committers":9,"mean_commits":51.0,"dds":0.1655773420479303,"last_synced_commit":"f1df82ed4358e47c682e007bc5aa306b58f25514"},"previous_names":["launchql/pgsql-parser","pyramation/pgsql-parser","constructive-io/pgsql-parser"],"tags_count":594,"template":false,"template_full_name":null,"purl":"pkg:github/constructive-io/pgsql-parser","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/constructive-io%2Fpgsql-parser","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/constructive-io%2Fpgsql-parser/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/constructive-io%2Fpgsql-parser/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/constructive-io%2Fpgsql-parser/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/constructive-io","download_url":"https://codeload.github.com/constructive-io/pgsql-parser/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/constructive-io%2Fpgsql-parser/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":32825693,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-05-08T08:22:46.396Z","status":"online","status_checked_at":"2026-05-09T02:00:06.633Z","response_time":123,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"}},"repo_metadata_updated_at":"2026-05-09T16:09:24.638Z","dependent_packages_count":0,"downloads":21996,"downloads_period":"last-month","dependent_repos_count":0,"rankings":{"downloads":null,"dependent_repos_count":23.146668180270176,"dependent_packages_count":33.38106860407916,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":28.26386839217467},"purl":"pkg:npm/plpgsql-parser","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/npm/plpgsql-parser","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/npm/plpgsql-parser","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/npm/plpgsql-parser/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2026-04-16T11:09:46.715Z","issues_count":1,"pull_requests_count":6,"avg_time_to_close_issue":null,"avg_time_to_close_pull_request":130424.25,"issues_closed_count":0,"pull_requests_closed_count":4,"pull_request_authors_count":2,"issue_authors_count":1,"avg_comments_per_issue":0.0,"avg_comments_per_pull_request":1.0,"merged_pull_requests_count":3,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":1,"past_year_pull_requests_count":6,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":130424.25,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":4,"past_year_pull_request_authors_count":2,"past_year_issue_authors_count":1,"past_year_avg_comments_per_issue":0.0,"past_year_avg_comments_per_pull_request":1.0,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":3,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/constructive-io%2Fpgsql-parser/issues","maintainers":[{"login":"pyramation","count":5,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/pyramation"}],"active_maintainers":[{"login":"pyramation","count":5,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/pyramation"}]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/plpgsql-parser/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/plpgsql-parser/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/plpgsql-parser/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/plpgsql-parser/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/plpgsql-parser/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/plpgsql-parser/codemeta","maintainers":[{"uuid":"pyramation","login":"pyramation","name":null,"email":"pyramation@gmail.com","url":null,"packages_count":1036,"html_url":"https://www.npmjs.com/~pyramation","role":null,"created_at":"2025-12-31T23:45:12.660Z","updated_at":"2025-12-31T23:45:12.660Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/pyramation/packages"}]}