{"id":2391898,"name":"sqlbits","ecosystem":"npm","description":"An assortment of powerful \u0026 well tested functions that assist in building SQL statements","homepage":"http://github.com/williamkapke/sqlbits","licenses":"MIT","normalized_licenses":["MIT"],"repository_url":"https://github.com/williamkapke/sqlbits","keywords_array":["sql","builder","sql builder","sql helper","postgres"],"namespace":null,"versions_count":13,"first_release_published_at":"2013-02-01T20:59:13.229Z","latest_release_published_at":"2015-03-31T20:58:45.385Z","latest_release_number":"2.2.1","last_synced_at":"2026-03-30T11:21:07.852Z","created_at":"2022-04-10T01:08:09.984Z","updated_at":"2026-03-30T11:21:07.852Z","registry_url":"https://www.npmjs.com/package/sqlbits","install_command":"npm install sqlbits","documentation_url":null,"metadata":{"funding":null,"dist-tags":{"latest":"2.2.1"}},"repo_metadata":{"id":6522858,"uuid":"7763796","full_name":"williamkapke/sqlbits","owner":"williamkapke","description":"An assortment of powerful \u0026 well tested functions that assist in building SQL statements","archived":false,"fork":false,"pushed_at":"2015-03-31T20:58:35.000Z","size":255,"stargazers_count":16,"open_issues_count":0,"forks_count":3,"subscribers_count":4,"default_branch":"master","last_synced_at":"2024-07-07T17:10:48.473Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":"","language":"JavaScript","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":null,"status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/williamkapke.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":null,"code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null}},"created_at":"2013-01-22T23:32:10.000Z","updated_at":"2021-07-19T10:48:49.000Z","dependencies_parsed_at":"2022-08-23T20:11:04.365Z","dependency_job_id":null,"html_url":"https://github.com/williamkapke/sqlbits","commit_stats":null,"previous_names":[],"tags_count":0,"template":false,"template_full_name":null,"repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/williamkapke%2Fsqlbits","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/williamkapke%2Fsqlbits/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/williamkapke%2Fsqlbits/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/williamkapke%2Fsqlbits/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/williamkapke","download_url":"https://codeload.github.com/williamkapke/sqlbits/tar.gz/refs/heads/master","host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":214725606,"owners_count":15775779,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2022-07-04T15:15:14.044Z","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"},"owner_record":{"login":"williamkapke","name":"TwistedKap","uuid":"739813","kind":"user","description":"Former: Node.js Board of Directors, @Tinder, @myspace","email":"","website":null,"location":"San Francisco","twitter":"twistedkap","company":"Technologist","icon_url":"https://avatars.githubusercontent.com/u/739813?u=542040041d9c67324d01414d3bfccfc3f4432843\u0026v=4","repositories_count":82,"last_synced_at":"2024-04-14T15:24:50.939Z","metadata":{"has_sponsors_listing":true},"html_url":"https://github.com/williamkapke","funding_links":["https://github.com/sponsors/williamkapke"],"total_stars":1693,"followers":255,"following":6,"created_at":"2022-11-02T16:48:03.109Z","updated_at":"2024-04-14T15:25:04.637Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/williamkapke","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/williamkapke/repositories"},"tags":[]},"repo_metadata_updated_at":"2024-08-09T21:09:26.792Z","dependent_packages_count":1,"downloads":12,"downloads_period":"last-month","dependent_repos_count":3,"rankings":{"downloads":16.72056850241828,"dependent_repos_count":6.355074938384495,"dependent_packages_count":20.947084095572265,"stargazers_count":8.282310069046398,"forks_count":8.871366574805107,"docker_downloads_count":null,"average":12.235280836045309},"purl":"pkg:npm/sqlbits","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/npm/sqlbits","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/npm/sqlbits","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/npm/sqlbits/dependencies","status":null,"funding_links":["https://github.com/sponsors/williamkapke"],"critical":null,"issue_metadata":{"last_synced_at":"2024-07-07T17:03:24.458Z","issues_count":2,"pull_requests_count":1,"avg_time_to_close_issue":17402714.0,"avg_time_to_close_pull_request":1824.0,"issues_closed_count":2,"pull_requests_closed_count":1,"pull_request_authors_count":1,"issue_authors_count":2,"avg_comments_per_issue":3.5,"avg_comments_per_pull_request":4.0,"merged_pull_requests_count":1,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":0,"past_year_pull_requests_count":0,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":null,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":0,"past_year_pull_request_authors_count":0,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":null,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":0,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/williamkapke%2Fsqlbits/issues","maintainers":[],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sqlbits/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sqlbits/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sqlbits/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sqlbits/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/packages/sqlbits/codemeta","maintainers":[{"uuid":"williamkapke","login":"williamkapke","name":null,"email":"william.kapke@gmail.com","url":null,"packages_count":51,"html_url":"https://www.npmjs.com/~williamkapke","role":null,"created_at":"2022-11-14T13:08:50.793Z","updated_at":"2022-11-14T13:08:50.793Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/npmjs.org/maintainers/williamkapke/packages"}]}