公开记录
软件健康报告模式 0.27.0 · 指标 1.13.0 · 2026-07-24 21:33 UTC

auraphp / Aura.SqlQuery

Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.

PHPMIT★ 456 星标⑂ 87 复刻始于 2013年9月在 GitHub 上查看 ↗

auraphp/Aura.SqlQuery 的健康指数为 100 分中的 58 分,处于「中等」区间。 其得分最高的类别是Sustainability & Governance(74/100),最低的是AI Readiness(27/100)。 最近一次更新在今天。 近期的大部分工作由 3 位贡献者完成。

58
总分 / 100
中等

软件健康指数

指标归入加权类别,统一采用 1–100 量表。总体分先取类别加权平均;当公开证据触发高风险司法辖区政策时,评级会按政策调整,并设置 49(有风险)的上限。AI 就绪度不计入总体分。

58
优秀85-100堪称典范;基本满足所有检验标准
良好70-84健康;仅有轻微不足
中等50-69可接受,但存在明显不足;建议进行审查
存在风险30-49存在重大薄弱环节;采用时应保持审慎
危急1-29问题严重(项目被弃置、仅有单一维护者、缺乏基本工程规范)
活力社区与采用可持续性与治理工程质量安全AI 就绪度

评分画像

每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形,而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。

所有权

63 关注者41 个公开仓库始于 2011年2月

该仓库由组织支持——共同承担、可问责的托管责任,可延续于任何单一维护者之后。

软件包生态系统

注册表软件包版本月下载量版本数最近发布标签
Packagistaura/sqlquery3.0.058,482161186 天前databasesqldbmysqlsqlitepostgresqlquerypdopgsqlpostgressql-serversqlserverupdateinsertselectdeletedml

按类别列示的指标

活力

项目是否仍有生命——是否仍在编写代码,是否仍在发布版本?

43存在风险 · 占总体的 22%

开发活跃度

42存在风险
评分方式
36/36推送新近度 — 最近一次推送于 0 天前
1.4/36提交节奏 — 52 周中有 2 周有提交
4.3/18提交量 — 最近一年 2 次提交
0/10OpenSSF Scorecard:Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
所用输入
commits_last_year2
human_commit_share1
days_since_last_push0
active_weeks_last_year2

发布纪律

44存在风险
评分方式
27/27有发布版本 — 已发布 16 个发布版本
0/36发布时效 — 最近一次发布版本于 1,186 天前
12.6/27发布节奏 — 约每 328 天发布一次
0/10OpenSSF Scorecard:Signed-Releases — 无数据
所用输入
releases_count16
latest_release_tag2.8.1
releases_from_tags
days_since_latest_release1,186
mean_days_between_releases328
已排除计分(无数据或不适用):OpenSSF Scorecard:Signed-Releases。 其余权重已重新归一化。

社区与采用

项目是否拥有用户、下载量与关注度,并具备欢迎贡献者参与的配置?

70良好 · 占总体的 18%
评分方式
43.1/60星标 — 456 个星标
16.1/25复刻 — 87 个复刻
8.3/15关注者 — 32 位关注者
所用输入
forks87
stars456
watchers32
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

社区健康

70良好
评分方式
22.5/22.5README
22.5/22.5许可证 — 可识别的许可证(MIT)
18/18CONTRIBUTING 指南
0/13.5行为准则
0/7.2议题模板
0/6.3PR 模板
所用输入
has_readme
has_license
has_contributing
has_issue_template
has_code_of_conduct
has_pull_request_template
评分方式
63.6/80月度下载量 — packagist 合计每月 58,482 次下载
11/20注册表被依赖数 — 43 个软件包依赖它
所用输入
packagesaura/sqlquery
dependents43
ecosystemspackagist
total_downloads3,166,534
monthly_downloads58,482

可持续性与治理

项目能否在其成员之外延续——巴士系数、响应能力、由谁支持,以及软件包的维护状况?

74良好 · 占总体的 24%
评分方式
36/54巴士系数 — 3 位贡献者贡献了半数提交
16.7/22.5提交分布 — 头号贡献者编写了 26% 的提交
13.5/13.5贡献者广度 — 36 位贡献者
10/10OpenSSF Scorecard:Contributors — project has 12 contributing companies or organizations
所用输入
bus_factor3
contributors_sampled36
top_contributor_share0.259
评分方式
36.3/46.8议题解决 — 78% 的议题已关闭
32.4/38.3PR 接受 — 已裁定的 PR 中 94/111 已合并
13.5/15OpenSSF Scorecard:Code-Review — Found 11/12 approved changesets -- score normalized to 9
所用输入
merged_prs94
open_issues22
closed_issues76
issue_closed_ratio0.776
closed_unmerged_prs17
评分方式
30/30所有权背书 — 组织持有
0/20已验证域名
13/25所有者影响力 — auraphp 有 63 位关注者
23.8/25既往记录 — 41 个公开仓库,账户约 15 年
所用输入
followers63
owner_typeOrganization
is_verified
owner_loginauraphp
public_repos41
account_age_days5,642
评分方式
25/25已发布且可解析 — packagist 上有 1 个软件包
4/35发布时效 — 最近一次发布于 1,186 天前
20/20版本历史 — 16 个已发布版本
20/20未被弃用 — 活跃,未被弃用或撤回
所用输入
packagesaura/sqlquery
ecosystemspackagist
any_deprecated
min_days_since_publish1,186

工程质量

基础的工程与文档实践是否到位?

59中等 · 占总体的 20%

工程实践

48存在风险
评分方式
24/24CI 工作流 — 1 个工作流
24/24存在测试
0/16Linter 配置
0/9.6Pre-commit 钩子
0/6.4.editorconfig
0/20OpenSSF Scorecard:CI-Tests — 1 out of 11 merged PRs checked by a CI test -- score normalized to 0
所用输入
has_ci
has_tests
has_editorconfig
has_linter_config
has_precommit_config

文档

75良好
评分方式
30/30README
25/25文档目录
0/15文档 / 主页站点
10/10仓库描述
10/10主题标签 — 6 个主题标签
0/10Wiki
所用输入
topicsquery-builder, php, mysql, postgresql, microsoft-sql-server, sqlite
has_wiki
homepage
has_readme
has_docs_dir
has_description

安全

可见的安全与供应链实践是否稳固,且不存在未解决的高风险司法辖区暴露?

43存在风险 · 占总体的 16%

安全态势

43存在风险
评分方式
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — 无数据
0/2.5CI-Tests — 1 out of 11 merged PRs checked by a CI test -- score normalized to 0
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
6.8/7.5Code-Review — Found 11/12 approved changesets -- score normalized to 9
2.5/2.5Contributors — project has 12 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5许可证 — license file detected
0/7.5Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
0/5Packaging — 无数据
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — 无数据
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
7.5/7.5Vulnerabilities — 0 existing vulnerabilities detected
所用输入
sourceopenssf_scorecard
checks_evaluated15
scorecard_versionv5.5.0
checks_inconclusive3
scorecard_aggregate4.3
已排除计分(无数据或不适用):branch_protection, packaging, signed_releases。 其余权重已重新归一化。

AI 就绪度

该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件?这是一枚独立的实验性徽章——权重为 0.0,因此单独呈现,不影响总体健康评分。

27危急 · 占总体的 0%
评分方式
0/45代理指令 — 没有 CLAUDE.md / AGENTS.md / 编辑器规则
0/15机器可读文档(llms.txt)
18.7/40可读的提交历史 — 100 次人类提交中有 35 次说明了意图(结构化标题或解释性正文)
所用输入
has_llms_txt
legible_history_share0.35
agent_instruction_files
agent_instruction_max_bytes
评分方式
0/18一条命令的引导启动
22/22自动化测试
0/11Lint / 格式化配置
0/11静态类型检查
0/10可复现环境
0/10已体现的代理实践 — 最近 100 次提交中没有代理编写的提交
0/8自动化维护 — 未观察到自动依赖更新
0/10OpenSSF Scorecard:Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
所用输入
has_nix
has_tests
lockfiles
has_dockerfile
typed_language
bootstrap_files
has_devcontainer
has_linter_config
typecheck_configs
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
评分方式
0/45可类型检查的代码 — PHP,未配置类型检查
55/55可控的文件大小 — 采样的 79 个源文件中有 0 个超过 60KB
所用输入
primary_languagePHP
largest_source_bytes30,633
source_files_sampled79
oversized_source_files0

关键数据

456GitHub 星标
36贡献者
2最近 12 个月提交数
0距最近推送天数
16发布版本数
3巴士系数(bus factor)
22开放议题
Packagist软件包生态系统数

数据采集警告

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • No resolved dependencies carried a version and a supported ecosystem

更多细节

Star 与 Fork 历史 0 ★ / 87 ⇿
0Star
87Fork
16发布

每颗 star 和每个 fork 的添加时间,来自 GitHub 并按天汇总。累计增长位于其构成来源——每日新增——的正上方,二者可相互对照:稳定的自然增长与短暂的突增形态截然不同。当这一差别可被衡量时,它会作为增长真实性予以报告。

0204060801008362013-102019-052024-12
主版本 2次版本 8修订 4

每个点涵盖 11 天。

OpenSSF Scorecard 4.3 / 10
4.3综合

来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身,而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用,并从安全评分中剔除(绝不按零分计)。Scorecard v5.5.0 · 2026-07-24 21:33 UTC

10Binary-Artifactsno binaries found in the repo
不适用Branch-Protectioninternal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md
0CI-Tests1 out of 11 merged PRs checked by a CI test -- score normalized to 0
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
9Code-ReviewFound 11/12 approved changesets -- score normalized to 9
10Contributorsproject has 12 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
0Maintained0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
不适用Packagingpackaging workflow not detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
不适用Signed-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
10Vulnerabilities0 existing vulnerabilities detected
全部依赖 3

来自 GitHub 依赖图的完整解析依赖集合:0 个直接依赖与 3 个间接(传递)软件包。仓库提交锁文件时,传递闭包才是完整的。

注册表软件包版本关系
Packagistext-pdo_sqlite间接
Packagistphp间接
Packagistyoast/phpunit-polyfills间接
依赖安全公告 未评估

本报告未能完成公告比对:No resolved dependencies carried a version and a supported ecosystem

原始 JSON 报告 机器可读
{
  "data": {
    "repo": {
      "topics": [
        "query-builder",
        "php",
        "mysql",
        "postgresql",
        "microsoft-sql-server",
        "sqlite"
      ],
      "is_fork": false,
      "size_kb": 1135,
      "has_wiki": false,
      "homepage": null,
      "languages": {
        "PHP": 196445
      },
      "pushed_at": "2026-07-24T21:26:25Z",
      "created_at": "2013-09-27T18:08:03Z",
      "owner_type": "Organization",
      "updated_at": "2026-07-14T14:07:17Z",
      "description": "Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "3.x",
      "license_spdx_raw": "MIT",
      "primary_language": "PHP",
      "significant_languages": [
        "PHP"
      ]
    },
    "owner": {
      "blog": "http://auraphp.com",
      "name": "Aura for PHP",
      "type": "Organization",
      "login": "auraphp",
      "company": null,
      "location": null,
      "followers": 63,
      "avatar_url": "https://avatars.githubusercontent.com/u/611900?v=4",
      "created_at": "2011-02-11T00:05:35Z",
      "is_verified": null,
      "public_repos": 41,
      "account_age_days": 5642
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": true
    },
    "activity": {
      "releases": [
        {
          "tag": "2.8.1",
          "kind": "patch",
          "published_at": "2023-04-25T13:29:38Z"
        },
        {
          "tag": "3.0.0",
          "kind": "major",
          "published_at": "2023-04-25T13:31:40Z"
        },
        {
          "tag": "2.8.0",
          "kind": "minor",
          "published_at": "2022-05-21T13:34:40Z"
        },
        {
          "tag": "3.0.0-alpha.1",
          "kind": "prerelease",
          "published_at": "2022-05-21T12:26:47Z"
        },
        {
          "tag": "2.7.1",
          "kind": "patch",
          "published_at": "2016-10-03T20:35:38Z"
        },
        {
          "tag": "2.7.0",
          "kind": "minor",
          "published_at": "2016-09-02T22:10:38Z"
        },
        {
          "tag": "2.6.0",
          "kind": "minor",
          "published_at": "2015-11-09T15:46:17Z"
        },
        {
          "tag": "2.5.0",
          "kind": "minor",
          "published_at": "2015-06-02T06:35:28Z"
        },
        {
          "tag": "2.4.2",
          "kind": "patch",
          "published_at": "2015-03-27T20:09:49Z"
        },
        {
          "tag": "2.4.1",
          "kind": "patch",
          "published_at": "2015-03-26T04:21:20Z"
        },
        {
          "tag": "2.4.0",
          "kind": "minor",
          "published_at": "2015-03-22T17:47:37Z"
        },
        {
          "tag": "2.3.0",
          "kind": "minor",
          "published_at": "2015-03-16T15:06:29Z"
        },
        {
          "tag": "2.2.0",
          "kind": "minor",
          "published_at": "2015-02-12T20:26:17Z"
        },
        {
          "tag": "2.1.0",
          "kind": "minor",
          "published_at": "2014-08-24T20:36:49Z"
        },
        {
          "tag": "2.0.0",
          "kind": "major",
          "published_at": "2014-06-09T16:07:06Z"
        },
        {
          "tag": "2.0.0-beta1",
          "kind": "prerelease",
          "published_at": "2014-01-07T16:17:44Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "b868202fdf9578d418d5f635b64934ec15e57099",
          "body": "Add PHP 8.4 and 8.5 to CI matrix",
          "is_bot": false,
          "headline": "Merge pull request #212 from koriym/feature/add-php84-85-ci",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2025-12-24T09:52:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e05dd03fbeec50fa69326fc195239a664b795f7d",
          "body": "Update LICENSE copyright year to 2025.\nUpdate README to reflect PHP 8.5 support.",
          "is_bot": false,
          "headline": "Add PHP 8.4 and 8.5 to CI matrix",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2025-12-09T05:24:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b58a7aab3c3291b31671ace4d64cc31e68f3f2a7",
          "body": "Updated Github Actions",
          "is_bot": false,
          "headline": "Merge pull request #210 from rotexdegba/3.x",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2024-03-14T04:50:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d37c20a3cba5834881236951b53b060abd6c6dda",
          "body": null,
          "is_bot": false,
          "headline": "Update QuoterTest.php",
          "author_name": "Rotimi Ade",
          "author_login": "rotexdegba",
          "committed_at": "2024-03-13T19:06:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "85e38a289ac84d7ee9ba3b39843ad00044ec2c6e",
          "body": "Made $this->quoter an explicitly defined property to prevent this warning in PHP 8.1+\r\n\r\nPHP Deprecated:  Creation of dynamic property Aura\\SqlQuery\\Common\\QuoterTest::$quoter is deprecated in /home/runner/work/Aura.SqlQuery/Aura.SqlQuery/tests/Common/QuoterTest.php on line 10",
          "is_bot": false,
          "headline": "Update QuoterTest.php",
          "author_name": "Rotimi Ade",
          "author_login": "rotexdegba",
          "committed_at": "2024-03-13T19:05:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "11e4fba942be5aa0c04600f0e00caf73b3de0476",
          "body": null,
          "is_bot": false,
          "headline": "Update continuous-integration.yml",
          "author_name": "Rotimi Ade",
          "author_login": "rotexdegba",
          "committed_at": "2024-03-13T18:56:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4113345a126a56da094aebd108f31eab8c89e60c",
          "body": null,
          "is_bot": false,
          "headline": "Update continuous-integration.yml",
          "author_name": "Rotimi Ade",
          "author_login": "rotexdegba",
          "committed_at": "2024-03-13T18:53:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "72ff740f19d8538cd1bdb46f73bc161e8fe88020",
          "body": "Update insert.md",
          "is_bot": false,
          "headline": "Merge pull request #208 from sajjad-rezaei/patch-1",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2023-06-02T10:44:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b92dffbbcb119181a983ef90d77d59b74ddd4185",
          "body": "fix closing array bracket",
          "is_bot": false,
          "headline": "Update insert.md",
          "author_name": "Sajjad Rezaei",
          "author_login": "sajjad-rezaei",
          "committed_at": "2023-06-02T07:20:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6f71a3b82d7018dff437cdd316f3eb851fd3713c",
          "body": "It is 100% valid for strripos to return 0\r\nwe want quotes in that case for the AS blah\r\nNEVER EVER if a strripos, always explicitly check for false!!\r\n\r\nThis was breaking jsonb text returns with mixed case aliases\r\n\r\nSelect \"pt\".\"name\"->>'en_US' AS \"myDescription\" from mytable pt is what we want to end up with\r\nThe replaceNamesAndAliasIn was getting ' AS myDescription' and not properly escaping it because the strripos was returning 0",
          "is_bot": false,
          "headline": "[BUG] Fix bad use of strripos",
          "author_name": "Elizabeth M Smith",
          "author_login": "auroraeosrose",
          "committed_at": "2023-04-25T13:21:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "265abd3e84d2715b1bcaa23e08b725213b77ba9b",
          "body": "Enable PHP 8.2 compat",
          "is_bot": false,
          "headline": "Merge pull request #204 from koriym/php8.2_support",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-12-12T05:15:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ded1fb4009fdff0c918d279d32cc6cc72534cff3",
          "body": null,
          "is_bot": false,
          "headline": "Refactor gitHub actions deprecated command",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-12-11T23:28:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "67f891ec66d36f2999e70636ad21a51ef64a9c75",
          "body": null,
          "is_bot": false,
          "headline": "Test with PHP 8.2",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-12-11T04:09:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "261d64d7c515779378047027c3c4a1cdbf512472",
          "body": null,
          "is_bot": false,
          "headline": "Update .gitignore",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-12-11T04:06:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "265066022f34cd03a883aaac8be2524a8b707602",
          "body": "Specify composer version to run up to PHP 7.1 with CI",
          "is_bot": false,
          "headline": "Merge pull request #202 from koriym/run_ci_on_php_71",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-05-11T12:21:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d14144dff8f07e1c2836fdc19f7ac5e375237157",
          "body": null,
          "is_bot": false,
          "headline": "Specify composer version to support PHP7.0/7.1",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-05-11T10:59:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7b3c1945c57f0293a63596d646fe2e2a7e8426e9",
          "body": "Fix deprecated test method",
          "is_bot": false,
          "headline": "Merge pull request #199 from koriym/fix-test",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-04T16:05:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4c99b8cd6a2710a79ccb77d55e798c87b81670ec",
          "body": null,
          "is_bot": false,
          "headline": "Fix deprecated test method",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-04T15:06:10Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b6a0a49570483557c3171bd1c2df75e1fa2acaf0",
          "body": "…rface\n\nAdd ignore() method to common Insert class",
          "is_bot": false,
          "headline": "Merge pull request #173 from maximTarleckiy/add-ignore-to-common-inte…",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-04T09:51:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "84b0a180e3850ab5c49cf2f0c9d702c1a795c46d",
          "body": "Refactor #162",
          "is_bot": false,
          "headline": "Merge pull request #198 from koriym/inline_array",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-04T08:23:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a2cee5be26fc43fbde84d6120f8417bf72a8420f",
          "body": "Support inline array for condition",
          "is_bot": false,
          "headline": "Merge pull request #162 from syrm/3.x",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-04T08:20:34Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d5d78ebc0dec1efc9f41047090b350d3ff6ff6d5",
          "body": null,
          "is_bot": false,
          "headline": "Add .gitattributes",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-04T07:11:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e5af1ed73cfebd2e39b5c71942ad252073a8820b",
          "body": null,
          "is_bot": false,
          "headline": "Add codecov.yml",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-04T07:07:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "66333facc3ec34cb16e75676798567c9f9af48c6",
          "body": null,
          "is_bot": false,
          "headline": "Extract getCond method",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-04T06:41:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "091f470e6d8ebbaafd978a7984b231a4f8279ecc",
          "body": "Fix types in phpdoc",
          "is_bot": false,
          "headline": "Merge pull request #197 from koriym/fix_type",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-04T04:12:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "02fbe59cf348d28e8d9a0b09f2c67355524dfd7a",
          "body": "…for-sqlite-extension\n\nAdd to composer ext-pdo_sqlite which required for tests",
          "is_bot": false,
          "headline": "Merge pull request #174 from maximTarleckiy/add-composer-requirement-…",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-03T18:00:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fa9a3964f85bff5462691071e1d30a8f51a3cc7b",
          "body": null,
          "is_bot": false,
          "headline": "Fixing merge conflicts made a invalid json.",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-03T17:59:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2424e1dff476936df4541629c2d6b57e328f2bd6",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch '3.x' into add-composer-requirement-for-sqlite-extension",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-03T17:57:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fb54a9ccd30a654bf400d329a58ba006cfae8011",
          "body": null,
          "is_bot": false,
          "headline": "Fix parameter name mismatch with interface",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T16:39:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "920cffb903cd9a5c12605618744e435a38b6eaa4",
          "body": null,
          "is_bot": false,
          "headline": "Fix types in phpdoc",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T16:38:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e2c8161282fe08d3f5926c901eb47aaa5cac9995",
          "body": "Fix typos",
          "is_bot": false,
          "headline": "Merge pull request #196 from koriym/fix_typos",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-03T16:01:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e94d118e4cd3cfdcf8048b8744bc909523680e94",
          "body": "Enable PHP 5.6-8.1 compat in 3.x",
          "is_bot": false,
          "headline": "Merge pull request #195 from koriym/gh_action",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2022-02-03T15:59:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4c91edc134f6c54887863893ae7321d1b6430110",
          "body": null,
          "is_bot": false,
          "headline": "Fix typos",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T15:32:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "449c001c04f4565253426caa729e13d62fda0d19",
          "body": null,
          "is_bot": false,
          "headline": "fixup! Enable PHP5.6-8.1 compat",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T15:17:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "44281c900ebb96e4e7272b76cdff28d90f95ff65",
          "body": null,
          "is_bot": false,
          "headline": "Update phpunit.xml.dist",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T15:05:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c0b6e12cbe174a5728b5bd038dc27499693f6165",
          "body": null,
          "is_bot": false,
          "headline": "Update CI badges",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T15:05:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "12682d99ae22f5c1a8458bb845c07f4484099077",
          "body": null,
          "is_bot": false,
          "headline": "Update copy-right year",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T14:58:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6989b41b9a0aed59063a1f4e50d882fc6e343c0b",
          "body": null,
          "is_bot": false,
          "headline": "Update .scrutinizer.yml",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T14:58:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2553535a1aaba4a22789d159115265cbe7d28f56",
          "body": null,
          "is_bot": false,
          "headline": "Remove .travis.yml",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T14:57:42Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2aa7ea6704bd5700b8075a5fc1489300e3e219fc",
          "body": null,
          "is_bot": false,
          "headline": "Upload test coverage report to codecov",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T14:57:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a8d9fd96346ea032a102444d8400c5886a0aa7c8",
          "body": null,
          "is_bot": false,
          "headline": "Add php5.6-7.1 test",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T14:54:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e4c91a5bdfddda10dcbecfd5c1fce10727fa0aa8",
          "body": null,
          "is_bot": false,
          "headline": "Adding GitHub Actions.",
          "author_name": "Brandon Savage",
          "author_login": "brandonsavage",
          "committed_at": "2022-02-03T14:52:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ccf7cfea6077ca62403828a6ff5a9d5693b28cec",
          "body": null,
          "is_bot": false,
          "headline": "Enable PHP5.6-8.1 compat",
          "author_name": "Akihito Koriyama",
          "author_login": "koriym",
          "committed_at": "2022-02-03T14:50:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4697be9a913e285c1234c68cd135095807d33fdd",
          "body": "fixes #178",
          "is_bot": false,
          "headline": "Merge pull request #179 from auraphp/issue-178",
          "author_name": "Paul M. Jones",
          "author_login": "pmjones",
          "committed_at": "2021-03-12T14:10:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5e54a0993061bd4202b963684ed4795c6a9c6ae4",
          "body": "minor typo in select.md",
          "is_bot": false,
          "headline": "Merge pull request #182 from cameronsteele/patch-3",
          "author_name": "Paul M. Jones",
          "author_login": "pmjones",
          "committed_at": "2021-03-10T15:54:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "30c170ca6e24d46f957a86fcd0b2d3fd42458469",
          "body": "improve select.md orderBy example",
          "is_bot": false,
          "headline": "Merge pull request #181 from cameronsteele/patch-2",
          "author_name": "Paul M. Jones",
          "author_login": "pmjones",
          "committed_at": "2021-03-10T15:54:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cff9d5b7c2bb99f5549bfdaab3402dacd4c596de",
          "body": "fix minor typo in instantiation.md",
          "is_bot": false,
          "headline": "Merge pull request #180 from cameronsteele/patch-1",
          "author_name": "Paul M. Jones",
          "author_login": "pmjones",
          "committed_at": "2021-03-10T15:53:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6fbd91aceffbd3402406d87f9d07a97367af7eb8",
          "body": null,
          "is_bot": false,
          "headline": "minor typo in select.md",
          "author_name": "Cameron Steele",
          "author_login": "cammytown",
          "committed_at": "2021-03-10T09:06:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bbd26aa5d25ab15e786871808926eb91b3778e40",
          "body": "Demonstrate usage of order method.",
          "is_bot": false,
          "headline": "improve select.md orderBy example",
          "author_name": "Cameron Steele",
          "author_login": "cammytown",
          "committed_at": "2021-03-10T07:55:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "21df6d1eb152713b80a79152e7ff64a338a8c913",
          "body": null,
          "is_bot": false,
          "headline": "minor typo in instantiation.md",
          "author_name": "Cameron Steele",
          "author_login": "cammytown",
          "committed_at": "2021-03-10T07:17:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f9e91ee8b9351b1de36483070f5d2efa4efb3e86",
          "body": null,
          "is_bot": false,
          "headline": "fixes #178",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2021-03-02T21:42:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "513747a1b399b910f6050e78bd64c3c125a81abf",
          "body": "Explain how to bind IN conditions",
          "is_bot": false,
          "headline": "Merge pull request #175 from afilina/patch-1",
          "author_name": "Paul M. Jones",
          "author_login": "pmjones",
          "committed_at": "2020-02-17T16:40:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e3c44e0a9b765de8bfc952360efd5d93c36d09c4",
          "body": null,
          "is_bot": false,
          "headline": "Explain how to bind IN conditions",
          "author_name": "Anna Filina",
          "author_login": "afilina",
          "committed_at": "2020-02-16T21:17:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4e98101f7390c01675913928986d2099a438927b",
          "body": null,
          "is_bot": false,
          "headline": "Add to composer ext-pdo_sqlite which required for tests",
          "author_name": "Maksims Tarleckis",
          "author_login": null,
          "committed_at": "2020-01-16T12:46:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "020bad71def1bf4bc4fc0a7bbd319124093a2f08",
          "body": null,
          "is_bot": false,
          "headline": "Add ignore() method to common Insert class",
          "author_name": "Maksims Tarleckis",
          "author_login": null,
          "committed_at": "2020-01-16T12:32:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8049fc6bcbe75a8196aa04af6a19ae79dfa75370",
          "body": "Test newer PHP versions on CI",
          "is_bot": false,
          "headline": "Merge pull request #169 from Bilge/patch-1",
          "author_name": "Paul M. Jones",
          "author_login": "pmjones",
          "committed_at": "2020-01-02T03:17:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9bf6273111e2d3695a6959997812f661154ef80a",
          "body": null,
          "is_bot": false,
          "headline": "Test newer PHP versions on CI",
          "author_name": "Bilge",
          "author_login": "Bilge",
          "committed_at": "2020-01-01T14:40:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "40a430ebe8ca6b897cd65bcd9c78f9b80d93fcaa",
          "body": null,
          "is_bot": false,
          "headline": "Support inline array for condition",
          "author_name": "Sylvain Robez-Masson",
          "author_login": null,
          "committed_at": "2018-04-03T09:33:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a4fd8dc4493d517ef3d06e1dbb9433c81fff16ce",
          "body": "Drop HHVM support v3.x",
          "is_bot": false,
          "headline": "Merge pull request #153 from odan/3.x",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2017-11-29T17:43:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6000e9f6767d5b757ce1e74f1233e6fa7ba24727",
          "body": "Make travis use trusty",
          "is_bot": false,
          "headline": "Merge pull request #148 from jakejohns/hotfix/travis",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2017-11-29T17:41:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0c41f46df863ecc0bb90c7f7b0ed59606fa0e5dc",
          "body": null,
          "is_bot": false,
          "headline": "Drop HHVM support #147",
          "author_name": "Daniel Opitz",
          "author_login": "odan",
          "committed_at": "2017-11-29T12:22:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9b252c11e06ae1c7b3e37a2a7a6105d777191e7a",
          "body": null,
          "is_bot": false,
          "headline": "Add php 7.1 to travis conf",
          "author_name": "jake johns",
          "author_login": "jakejohns",
          "committed_at": "2017-10-24T16:01:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5c7fb0b2192991e6855981a4bc86a4e77f4b58c0",
          "body": null,
          "is_bot": false,
          "headline": "Make travis use trusty",
          "author_name": "jake johns",
          "author_login": "jakejohns",
          "committed_at": "2017-07-21T23:58:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "605548ca0a1eb08327807bec49d49cc206e91651",
          "body": "Add missing closing ``` in docs/select.md",
          "is_bot": false,
          "headline": "Merge pull request #144 from johnchen902/patch-1",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-06-03T15:40:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "65a315f648adc2ab7c35270b7804529ef10da755",
          "body": null,
          "is_bot": false,
          "headline": "Add missing closing ``` in docs/select.md",
          "author_name": "John Chen",
          "author_login": "johnchen902",
          "committed_at": "2017-06-03T11:26:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b1bcd35f21e1c63c743b9f60877b364be79d56b3",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch '3.x' of github.com:auraphp/Aura.SqlQuery into 3.x",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-19T14:50:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "052e05453251dae4d7c830be80b1aca3b674f23f",
          "body": null,
          "is_bot": false,
          "headline": "continue updating docs",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-19T14:50:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cd93d4272bdd31d7d7c2ab55cd68260afe2c4549",
          "body": "Add \"table dot star\" assertion to quoter test",
          "is_bot": false,
          "headline": "Merge pull request #140 from djmattyg007/add_quotertest_assertion",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-19T14:48:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f38d290b3d667b8308dad40fe98bf02c16f60412",
          "body": "Only fall back to common quoter when DB-specific quoter doesn't exist",
          "is_bot": false,
          "headline": "Merge pull request #141 from djmattyg007/fix_quoter_instantiation",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-18T15:48:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a26ae17c0c3442b8f6847397b4939d01fb154c6b",
          "body": null,
          "is_bot": false,
          "headline": "Only fall back to common quoter when DB-specific quoter doesn't exist",
          "author_name": "Matthew Gamble",
          "author_login": "djmattyg007",
          "committed_at": "2017-04-18T03:58:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d15014960f2998853ce88270296434082eed55db",
          "body": null,
          "is_bot": false,
          "headline": "Add \"table dot star\" assertion to quoter test",
          "author_name": "Matthew Gamble",
          "author_login": "djmattyg007",
          "committed_at": "2017-04-16T01:51:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "485d31b32c5940174558387c38054ea457acbc38",
          "body": null,
          "is_bot": false,
          "headline": "update docblocks",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-14T21:58:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "eb25b93c4ff02e8a6076820e9f171dabbcfab107",
          "body": null,
          "is_bot": false,
          "headline": "update docblocks",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-14T21:58:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0a3e42bef7f64f814a287317824c1b687a13fbcd",
          "body": null,
          "is_bot": false,
          "headline": "update docblocks",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-14T20:08:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3318bdf6d112d524d820e63d795466d0041c7e5b",
          "body": null,
          "is_bot": false,
          "headline": "use MIT license",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-14T19:06:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fe9785340bc8ba344fb41e94eebfaa6af64ae7fc",
          "body": null,
          "is_bot": false,
          "headline": "use vendor phpunit",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-14T19:06:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bda66e1ef383fc0b6aa5db8ddac3d61cf68b7624",
          "body": null,
          "is_bot": false,
          "headline": "update composer metadata",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-14T19:06:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2035782bd601f995fe00b23e2e107db0a8aefbb3",
          "body": null,
          "is_bot": false,
          "headline": "update docs",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-14T19:00:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fa5e79deafb44ee08dd869dbab751339184f4cc3",
          "body": null,
          "is_bot": false,
          "headline": "update license years",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-04-14T19:00:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "713ad5c9d6b83cc5b7db8adf86ee377ca3a06032",
          "body": null,
          "is_bot": false,
          "headline": "remove php tags from docs",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T19:53:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "dd21e32eea37a77763c62df263261424139d7f06",
          "body": "Support 'grouping' of where() and having() conditions",
          "is_bot": false,
          "headline": "Merge pull request #136 from auraphp/3.x-parens-around-conditions",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T19:37:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "10ec2f08e3de156a0c0f4f33f89957714bc7fcbc",
          "body": null,
          "is_bot": false,
          "headline": "add having() closure test",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T17:18:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b5ecf257525de240bf5bea720eb5578646f02d06",
          "body": "This allows for where(function($select){...}), and put parens around the resulting conditions",
          "is_bot": false,
          "headline": "support 'grouping' of where() and having() conditions",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T16:53:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "def68e2037ebf0858acaa250b5be97008aa05a48",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch '3.x' of github.com:auraphp/Aura.SqlQuery into 3.x",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T15:57:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7ad42c67e392171a460c899689f9b5826fc32d9f",
          "body": null,
          "is_bot": false,
          "headline": "docblock",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T15:57:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3d57c42bb728a7292f5f30a458c5e71a0c13008f",
          "body": "Fixes #125",
          "is_bot": false,
          "headline": "Merge pull request #135 from auraphp/harikt-patch-1",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T15:55:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8e06753e76b7ea385fba7332577d92af95efe8fa",
          "body": null,
          "is_bot": false,
          "headline": "Fixes #125",
          "author_name": "Hari K T",
          "author_login": "harikt",
          "committed_at": "2017-03-22T15:55:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "98a986d06091ae7f1156be766b7afdc9c6181e6e",
          "body": "3.x: Named placeholders only for where() et al. conditions",
          "is_bot": false,
          "headline": "Merge pull request #134 from auraphp/3.x-named-placeholders-only",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T14:28:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0328669f9d4f49003db5e8cf5868f094c04083c6",
          "body": null,
          "is_bot": false,
          "headline": "use SelectInterface, not SubSelectInterface",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T14:15:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3be4c853ce5337d40c772f2b80bbaea460fd2f9f",
          "body": "Remove SubSelect interface, typehint on SelectInterface instead",
          "is_bot": false,
          "headline": "Merge pull request #133 from auraphp/3.x-subselect-interface",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-22T14:12:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b69470237a01865d2260532d4a3ac438cd164a7c",
          "body": null,
          "is_bot": false,
          "headline": "clean up diff",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T21:05:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "93047d3d3af21530ff2126babf4645eaaeab2e10",
          "body": null,
          "is_bot": false,
          "headline": "no more need to track instance counts now that seq prefixes are not used",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T21:03:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b88cbedee47e8e9eedf5d7cd8a58b2e3bc5b6553",
          "body": null,
          "is_bot": false,
          "headline": "whitespace",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T21:01:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "33ccf7af7e094592ff5c06e41f23f9edea236b6f",
          "body": null,
          "is_bot": false,
          "headline": "remove seq-bind prefixing methods",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T20:59:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4af5995ebff4637223550d1398f26e64a029c533",
          "body": null,
          "is_bot": false,
          "headline": "in tests, change :_?_ to :named placeholder",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T20:51:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bc794818a6c09bc84ba585c934b17bff4af0b057",
          "body": null,
          "is_bot": false,
          "headline": "add back subselects as join conditions",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T20:42:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "913a85ebf7bf05e91cc7b7a01717d966737a3b4a",
          "body": null,
          "is_bot": false,
          "headline": "join*() now support only named binding",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T20:22:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8920d820f05d515f2ff68558a3b7126550464bbe",
          "body": null,
          "is_bot": false,
          "headline": "move method to only place it is used",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T20:11:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6a3d98e2bb6a4f790b130aa2ed033dde2814434b",
          "body": null,
          "is_bot": false,
          "headline": "where() and having() now support only named binding",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T20:07:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fcb764c45569ba11fb1b816d804805ac2b1db0f4",
          "body": null,
          "is_bot": false,
          "headline": "remove addWhere() in favor of addClauseCondWithBind()",
          "author_name": "Paul M. Jones",
          "author_login": null,
          "committed_at": "2017-03-21T19:26:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 16,
      "commits_last_year": 2,
      "latest_release_at": "2023-04-25T13:29:38Z",
      "latest_release_tag": "2.8.1",
      "releases_from_tags": false,
      "days_since_last_push": 0,
      "active_weeks_last_year": 2,
      "days_since_latest_release": 1186,
      "mean_days_between_releases": 328
    },
    "community": {
      "has_readme": true,
      "has_license": true,
      "has_description": true,
      "has_contributing": true,
      "health_percentage": 50,
      "has_issue_template": false,
      "has_code_of_conduct": false,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": [
        {
          "name": "aura/sqlquery",
          "exists": true,
          "license": "MIT",
          "keywords": [
            "database",
            "sql",
            "db",
            "mysql",
            "sqlite",
            "postgresql",
            "query",
            "pdo",
            "pgsql",
            "postgres",
            "sql server",
            "sqlserver",
            "update",
            "insert",
            "select",
            "delete",
            "dml"
          ],
          "ecosystem": "packagist",
          "matches_repo": true,
          "registry_url": "https://packagist.org/packages/aura/sqlquery",
          "is_deprecated": false,
          "latest_version": "3.0.0",
          "repository_url": "https://github.com/auraphp/Aura.SqlQuery",
          "versions_count": 16,
          "total_downloads": 3166534,
          "dependents_count": 43,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": 58482,
          "first_published_at": null,
          "latest_published_at": "2023-04-25T13:21:16Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 1186
        }
      ]
    },
    "popularity": {
      "forks": 87,
      "stars": 456,
      "watchers": 32,
      "fork_history": {
        "days": [
          {
            "date": "2013-10-03",
            "count": 1
          },
          {
            "date": "2014-01-28",
            "count": 1
          },
          {
            "date": "2014-02-21",
            "count": 1
          },
          {
            "date": "2014-06-26",
            "count": 1
          },
          {
            "date": "2014-07-02",
            "count": 1
          },
          {
            "date": "2014-08-05",
            "count": 1
          },
          {
            "date": "2014-10-14",
            "count": 1
          },
          {
            "date": "2014-12-03",
            "count": 1
          },
          {
            "date": "2015-02-04",
            "count": 1
          },
          {
            "date": "2015-02-05",
            "count": 2
          },
          {
            "date": "2015-03-06",
            "count": 1
          },
          {
            "date": "2015-03-17",
            "count": 3
          },
          {
            "date": "2015-03-19",
            "count": 2
          },
          {
            "date": "2015-03-24",
            "count": 1
          },
          {
            "date": "2015-04-07",
            "count": 1
          },
          {
            "date": "2015-04-21",
            "count": 1
          },
          {
            "date": "2015-05-15",
            "count": 1
          },
          {
            "date": "2015-08-27",
            "count": 1
          },
          {
            "date": "2015-08-31",
            "count": 1
          },
          {
            "date": "2015-09-09",
            "count": 1
          },
          {
            "date": "2015-09-14",
            "count": 1
          },
          {
            "date": "2015-10-20",
            "count": 1
          },
          {
            "date": "2015-10-31",
            "count": 1
          },
          {
            "date": "2015-12-10",
            "count": 1
          },
          {
            "date": "2016-01-13",
            "count": 1
          },
          {
            "date": "2016-04-21",
            "count": 1
          },
          {
            "date": "2016-05-07",
            "count": 1
          },
          {
            "date": "2016-05-18",
            "count": 1
          },
          {
            "date": "2016-05-23",
            "count": 1
          },
          {
            "date": "2016-06-13",
            "count": 1
          },
          {
            "date": "2016-08-08",
            "count": 1
          },
          {
            "date": "2016-10-12",
            "count": 1
          },
          {
            "date": "2016-10-28",
            "count": 1
          },
          {
            "date": "2017-01-21",
            "count": 1
          },
          {
            "date": "2017-02-20",
            "count": 1
          },
          {
            "date": "2017-04-16",
            "count": 1
          },
          {
            "date": "2017-07-17",
            "count": 1
          },
          {
            "date": "2017-07-21",
            "count": 1
          },
          {
            "date": "2017-10-19",
            "count": 1
          },
          {
            "date": "2018-02-07",
            "count": 1
          },
          {
            "date": "2018-02-24",
            "count": 1
          },
          {
            "date": "2018-03-22",
            "count": 1
          },
          {
            "date": "2018-04-02",
            "count": 1
          },
          {
            "date": "2018-05-02",
            "count": 1
          },
          {
            "date": "2018-05-18",
            "count": 1
          },
          {
            "date": "2018-05-30",
            "count": 1
          },
          {
            "date": "2018-09-21",
            "count": 1
          },
          {
            "date": "2018-11-10",
            "count": 1
          },
          {
            "date": "2018-12-13",
            "count": 1
          },
          {
            "date": "2019-01-21",
            "count": 1
          },
          {
            "date": "2019-03-21",
            "count": 1
          },
          {
            "date": "2019-07-06",
            "count": 1
          },
          {
            "date": "2019-07-19",
            "count": 1
          },
          {
            "date": "2019-09-06",
            "count": 1
          },
          {
            "date": "2019-11-11",
            "count": 1
          },
          {
            "date": "2020-01-01",
            "count": 1
          },
          {
            "date": "2020-01-16",
            "count": 1
          },
          {
            "date": "2020-02-16",
            "count": 1
          },
          {
            "date": "2020-03-21",
            "count": 1
          },
          {
            "date": "2020-04-08",
            "count": 1
          },
          {
            "date": "2020-11-19",
            "count": 1
          },
          {
            "date": "2021-03-10",
            "count": 1
          },
          {
            "date": "2021-05-02",
            "count": 1
          },
          {
            "date": "2021-06-26",
            "count": 1
          },
          {
            "date": "2021-09-21",
            "count": 1
          },
          {
            "date": "2021-10-27",
            "count": 1
          },
          {
            "date": "2022-01-05",
            "count": 1
          },
          {
            "date": "2022-01-07",
            "count": 1
          },
          {
            "date": "2022-01-27",
            "count": 1
          },
          {
            "date": "2022-10-02",
            "count": 1
          },
          {
            "date": "2023-06-02",
            "count": 1
          },
          {
            "date": "2023-10-31",
            "count": 1
          },
          {
            "date": "2024-03-13",
            "count": 1
          },
          {
            "date": "2024-06-16",
            "count": 1
          },
          {
            "date": "2024-06-23",
            "count": 1
          },
          {
            "date": "2024-09-25",
            "count": 1
          },
          {
            "date": "2024-09-26",
            "count": 2
          },
          {
            "date": "2024-12-12",
            "count": 1
          }
        ],
        "complete": true,
        "collected": 83,
        "total_forks": 87
      },
      "star_history": null,
      "open_issues_and_prs": 25
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [],
      "has_llms_txt": false,
      "has_dockerfile": false,
      "has_mcp_signal": false,
      "bootstrap_files": [],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "toolchain_manifests": [],
      "largest_source_bytes": 30633,
      "source_files_sampled": 79,
      "oversized_source_files": 0,
      "agent_instruction_files": [],
      "agent_instruction_max_bytes": null
    },
    "dependencies": {
      "manifests": [
        "composer.json"
      ],
      "advisories": {
        "error": "No resolved dependencies carried a version and a supported ecosystem",
        "scope": "repository_graph",
        "source": null,
        "findings": [],
        "collected": false,
        "malicious": [],
        "truncated": false,
        "by_severity": {},
        "advisory_count": 0,
        "affected_count": 0,
        "assessed_count": 0,
        "malicious_count": 0,
        "assessed_package": null,
        "unassessed_count": 3,
        "direct_affected_count": 0
      },
      "ecosystems": [
        "packagist"
      ],
      "dependencies": [],
      "all_dependencies": {
        "error": null,
        "source": "github-sbom",
        "packages": [
          {
            "name": "ext-pdo_sqlite",
            "direct": false,
            "version": null,
            "ecosystem": "packagist"
          },
          {
            "name": "php",
            "direct": false,
            "version": null,
            "ecosystem": "packagist"
          },
          {
            "name": "yoast/phpunit-polyfills",
            "direct": false,
            "version": null,
            "ecosystem": "packagist"
          }
        ],
        "collected": true,
        "truncated": false,
        "total_count": 3,
        "direct_count": 0,
        "indirect_count": 3
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 3,
        "merged_prs": 94,
        "open_issues": 22,
        "closed_ratio": 0.776,
        "closed_issues": 76,
        "closed_unmerged_prs": 17
      },
      "bus_factor": 3,
      "bot_contributors": 0,
      "top_contributors": [
        {
          "type": "User",
          "login": "harikt",
          "commits": 52,
          "avatar_url": "https://avatars.githubusercontent.com/u/120454?v=4"
        },
        {
          "type": "User",
          "login": "MAXakaWIZARD",
          "commits": 31,
          "avatar_url": "https://avatars.githubusercontent.com/u/1138453?v=4"
        },
        {
          "type": "User",
          "login": "koriym",
          "commits": 27,
          "avatar_url": "https://avatars.githubusercontent.com/u/529021?v=4"
        },
        {
          "type": "User",
          "login": "pavarnos",
          "commits": 20,
          "avatar_url": "https://avatars.githubusercontent.com/u/589595?v=4"
        },
        {
          "type": "User",
          "login": "mindplay-dk",
          "commits": 12,
          "avatar_url": "https://avatars.githubusercontent.com/u/103348?v=4"
        },
        {
          "type": "User",
          "login": "kornrunner",
          "commits": 7,
          "avatar_url": "https://avatars.githubusercontent.com/u/725986?v=4"
        },
        {
          "type": "User",
          "login": "pmjones",
          "commits": 6,
          "avatar_url": "https://avatars.githubusercontent.com/u/25754?v=4"
        },
        {
          "type": "User",
          "login": "rotexdegba",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/1242622?v=4"
        },
        {
          "type": "User",
          "login": "nyamsprod",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/51073?v=4"
        },
        {
          "type": "User",
          "login": "cammytown",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/735509?v=4"
        }
      ],
      "contributors_sampled": 36,
      "top_contributor_share": 0.259
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "continuous-integration.yml"
      ],
      "has_docs_dir": true,
      "linter_configs": [],
      "has_editorconfig": false,
      "has_linter_config": false,
      "has_precommit_config": false
    },
    "security_signals": {
      "lockfiles": [],
      "scorecard": {
        "checks": [
          {
            "name": "Binary-Artifacts",
            "score": 10,
            "reason": "no binaries found in the repo",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
          },
          {
            "name": "Branch-Protection",
            "score": null,
            "reason": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
          },
          {
            "name": "CI-Tests",
            "score": 0,
            "reason": "1 out of 11 merged PRs checked by a CI test -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
          },
          {
            "name": "CII-Best-Practices",
            "score": 0,
            "reason": "no effort to earn an OpenSSF best practices badge detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
          },
          {
            "name": "Code-Review",
            "score": 9,
            "reason": "Found 11/12 approved changesets -- score normalized to 9",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 10,
            "reason": "project has 12 contributing companies or organizations",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": 10,
            "reason": "no dangerous workflow patterns detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
          },
          {
            "name": "Dependency-Update-Tool",
            "score": 0,
            "reason": "no update tool detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
          },
          {
            "name": "Fuzzing",
            "score": 0,
            "reason": "project is not fuzzed",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
          },
          {
            "name": "License",
            "score": 10,
            "reason": "license file detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
          },
          {
            "name": "Maintained",
            "score": 0,
            "reason": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
          },
          {
            "name": "Packaging",
            "score": null,
            "reason": "packaging workflow not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
          },
          {
            "name": "Pinned-Dependencies",
            "score": 0,
            "reason": "dependency not pinned by hash detected -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
          },
          {
            "name": "SAST",
            "score": 0,
            "reason": "SAST tool is not run on all commits -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
          },
          {
            "name": "Security-Policy",
            "score": 0,
            "reason": "security policy file not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
          },
          {
            "name": "Signed-Releases",
            "score": null,
            "reason": "no releases found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
          },
          {
            "name": "Token-Permissions",
            "score": 0,
            "reason": "detected GitHub workflow tokens with excessive permissions",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
          },
          {
            "name": "Vulnerabilities",
            "score": 10,
            "reason": "0 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "b868202fdf9578d418d5f635b64934ec15e57099",
        "ran_at": "2026-07-24T21:33:10Z",
        "aggregate_score": 4.3,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": false
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": "2026-07-24T21:27:14Z",
      "oldest_open_prs": [
        {
          "number": 142,
          "created_at": "2017-04-19T21:14:20Z",
          "last_comment_at": "2022-02-04T13:47:31Z",
          "last_comment_author": "pmjones"
        },
        {
          "number": 165,
          "created_at": "2018-05-02T14:22:55Z",
          "last_comment_at": "2018-05-02T14:50:14Z",
          "last_comment_author": "dc2xl"
        },
        {
          "number": 184,
          "created_at": "2021-05-02T10:23:51Z",
          "last_comment_at": "2021-06-02T06:56:30Z",
          "last_comment_author": "golgote"
        }
      ],
      "last_merged_pr_at": "2025-12-24T09:52:37Z",
      "ci_last_conclusion": "SUCCESS",
      "oldest_open_issues": [
        {
          "number": 104,
          "created_at": "2016-09-03T21:27:17Z",
          "last_comment_at": "2017-03-22T14:44:02Z",
          "last_comment_author": "pmjones"
        },
        {
          "number": 124,
          "created_at": "2017-01-24T15:13:00Z",
          "last_comment_at": "2017-03-22T15:50:16Z",
          "last_comment_author": "pavarnos"
        },
        {
          "number": 130,
          "created_at": "2017-03-06T10:42:05Z",
          "last_comment_at": "2017-03-11T15:27:34Z",
          "last_comment_author": "pmjones"
        },
        {
          "number": 139,
          "created_at": "2017-04-16T01:48:32Z",
          "last_comment_at": "2017-04-20T18:16:45Z",
          "last_comment_author": "harikt"
        },
        {
          "number": 143,
          "created_at": "2017-05-22T11:52:04Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 149,
          "created_at": "2017-07-25T12:43:50Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 151,
          "created_at": "2017-09-14T09:48:30Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 155,
          "created_at": "2017-12-06T15:25:21Z",
          "last_comment_at": "2021-05-02T10:52:46Z",
          "last_comment_author": "golgote"
        },
        {
          "number": 157,
          "created_at": "2018-02-01T18:59:16Z",
          "last_comment_at": "2022-05-21T12:17:16Z",
          "last_comment_author": "harikt"
        },
        {
          "number": 158,
          "created_at": "2018-02-26T18:21:29Z",
          "last_comment_at": "2018-02-28T21:57:15Z",
          "last_comment_author": "designermonkey"
        },
        {
          "number": 160,
          "created_at": "2018-03-07T18:22:05Z",
          "last_comment_at": "2018-03-08T13:05:01Z",
          "last_comment_author": "pmjones"
        },
        {
          "number": 161,
          "created_at": "2018-03-21T15:40:14Z",
          "last_comment_at": "2020-10-21T16:24:00Z",
          "last_comment_author": "jimbo8098"
        },
        {
          "number": 164,
          "created_at": "2018-04-24T14:47:49Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 171,
          "created_at": "2020-01-10T06:54:05Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 172,
          "created_at": "2020-01-13T14:29:34Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 176,
          "created_at": "2020-02-22T12:44:38Z",
          "last_comment_at": "2020-10-20T21:00:09Z",
          "last_comment_author": "jimbo8098"
        },
        {
          "number": 177,
          "created_at": "2020-05-28T17:10:13Z",
          "last_comment_at": "2020-05-28T18:45:04Z",
          "last_comment_author": "otelconsulting"
        },
        {
          "number": 183,
          "created_at": "2021-03-24T15:10:32Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 189,
          "created_at": "2021-09-01T20:20:50Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 192,
          "created_at": "2022-01-04T12:58:07Z",
          "last_comment_at": "2024-04-24T16:29:21Z",
          "last_comment_author": "anoxia"
        }
      ]
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/auraphp/Aura.SqlQuery",
    "host": "github.com",
    "name": "Aura.SqlQuery",
    "owner": "auraphp"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "moderate",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 58,
      "inputs": {
        "security": 43,
        "vitality": 43,
        "community": 70,
        "governance": 74,
        "engineering": 59
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "at_risk",
        "name": "Vitality",
        "value": 43,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "at_risk",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 42,
            "inputs": {
              "commits_last_year": 2,
              "human_commit_share": 1,
              "days_since_last_push": 0,
              "active_weeks_last_year": 2
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 0 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 0
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "2/52 weeks with commits",
                "points": 1.4,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 2
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "2 commits in the last year",
                "points": 4.3,
                "status": "partial",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 2
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "at_risk",
            "name": "Release discipline",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 44,
            "inputs": {
              "releases_count": 16,
              "latest_release_tag": "2.8.1",
              "releases_from_tags": false,
              "days_since_latest_release": 1186,
              "mean_days_between_releases": 328
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "16 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 16
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 1186 days ago",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 1186
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~328 days",
                "points": 12.6,
                "status": "partial",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 328
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "openssf_scorecard_signed_releases",
                "name": "OpenSSF Scorecard: Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 10
              }
            ]
          },
          {
            "key": "abandonment",
            "band": "excellent",
            "name": "Abandonment",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "cap": null,
              "state": "dormant",
              "guards": [],
              "signals": [
                "issue_rot",
                "scorecard_unmaintained"
              ],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": null,
              "unanswered_open_prs": 3,
              "unanswered_open_issues": 14,
              "days_since_last_merged_pr": 212,
              "days_since_last_human_commit": 212,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "no human commit for 212 days, with nothing left unanswered",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_quiet",
                    "params": {
                      "days": 212
                    }
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "good",
        "name": "Community & Adoption",
        "value": 70,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "moderate",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 68,
            "inputs": {
              "forks": 87,
              "stars": 456,
              "watchers": 32,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "456 stars",
                "points": 43.1,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 456
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "87 forks",
                "points": 16.1,
                "status": "partial",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 87
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "32 watchers",
                "points": 8.3,
                "status": "partial",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 32
                    }
                  }
                ],
                "max_points": 15
              }
            ]
          },
          {
            "key": "community_health",
            "band": "good",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 70,
            "inputs": {
              "has_readme": true,
              "has_license": true,
              "has_contributing": true,
              "has_issue_template": false,
              "has_code_of_conduct": false,
              "has_pull_request_template": false
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 22.5,
                "status": "met",
                "details": [],
                "max_points": 22.5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "recognized license (MIT)",
                "points": 22.5,
                "status": "met",
                "details": [
                  {
                    "code": "license_standard",
                    "params": {}
                  },
                  {
                    "code": "license_spdx",
                    "params": {
                      "spdx": "MIT"
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributing_guide",
                "name": "CONTRIBUTING guide",
                "detail": null,
                "points": 18,
                "status": "met",
                "details": [],
                "max_points": 18
              },
              {
                "key": "code_of_conduct",
                "name": "Code of conduct",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 13.5
              },
              {
                "key": "issue_template",
                "name": "Issue template",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.2
              },
              {
                "key": "pr_template",
                "name": "PR template",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.3
              }
            ]
          },
          {
            "key": "ecosystem_adoption",
            "band": "good",
            "name": "Ecosystem adoption (downloads)",
            "note": null,
            "notes": [],
            "value": 75,
            "inputs": {
              "packages": [
                "aura/sqlquery"
              ],
              "dependents": 43,
              "ecosystems": "packagist",
              "total_downloads": 3166534,
              "monthly_downloads": 58482
            },
            "components": [
              {
                "key": "monthly_downloads",
                "name": "Monthly downloads",
                "detail": "58,482 downloads/month across packagist",
                "points": 63.6,
                "status": "partial",
                "details": [
                  {
                    "code": "downloads_monthly",
                    "params": {
                      "count": 58482,
                      "ecosystems": "packagist"
                    }
                  }
                ],
                "max_points": 80
              },
              {
                "key": "registry_dependents",
                "name": "Registry dependents",
                "detail": "43 packages depend on it",
                "points": 11,
                "status": "partial",
                "details": [
                  {
                    "code": "registry_dependents",
                    "params": {
                      "count": 43
                    }
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
      },
      {
        "key": "governance",
        "band": "good",
        "name": "Sustainability & Governance",
        "value": 74,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "good",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 76,
            "inputs": {
              "bus_factor": 3,
              "contributors_sampled": 36,
              "top_contributor_share": 0.259
            },
            "components": [
              {
                "key": "bus_factor",
                "name": "Bus factor",
                "detail": "3 contributor(s) cover half of all commits",
                "points": 36,
                "status": "partial",
                "details": [
                  {
                    "code": "bus_factor",
                    "params": {
                      "count": 3
                    }
                  }
                ],
                "max_points": 54
              },
              {
                "key": "commit_distribution",
                "name": "Commit distribution",
                "detail": "top contributor authored 26% of commits",
                "points": 16.7,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 26
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "36 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 36
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 12 contributing companies or organizations",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": null,
            "notes": [],
            "value": 82,
            "inputs": {
              "merged_prs": 94,
              "open_issues": 22,
              "closed_issues": 76,
              "issue_closed_ratio": 0.776,
              "closed_unmerged_prs": 17
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "78% of issues closed",
                "points": 36.3,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 78
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "94/111 decided PRs merged",
                "points": 32.4,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 94,
                      "decided": 111
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 11/12 approved changesets -- score normalized to 9",
                "points": 13.5,
                "status": "partial",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "moderate",
            "name": "Ownership & stewardship",
            "note": null,
            "notes": [],
            "value": 67,
            "inputs": {
              "followers": 63,
              "owner_type": "Organization",
              "is_verified": null,
              "owner_login": "auraphp",
              "public_repos": 41,
              "account_age_days": 5642
            },
            "components": [
              {
                "key": "ownership_backing",
                "name": "Ownership backing",
                "detail": "organization-owned",
                "points": 30,
                "status": "met",
                "details": [
                  {
                    "code": "owner_organization",
                    "params": {}
                  }
                ],
                "max_points": 30
              },
              {
                "key": "verified_domain",
                "name": "Verified domain",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              },
              {
                "key": "owner_reach",
                "name": "Owner reach",
                "detail": "63 followers of auraphp",
                "points": 13,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 63,
                      "login": "auraphp"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "41 public repos, account ~15 yr old",
                "points": 23.8,
                "status": "partial",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 41
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 15
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "moderate",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 69,
            "inputs": {
              "packages": [
                "aura/sqlquery"
              ],
              "ecosystems": "packagist",
              "any_deprecated": false,
              "min_days_since_publish": 1186
            },
            "components": [
              {
                "key": "published_resolvable",
                "name": "Published & resolvable",
                "detail": "1 package(s) on packagist",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "packages_published",
                    "params": {
                      "count": 1,
                      "ecosystems": "packagist"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "publish_recency",
                "name": "Publish recency",
                "detail": "latest publish 1186 days ago",
                "points": 4,
                "status": "partial",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 1186
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "16 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 16
                    }
                  }
                ],
                "max_points": 20
              },
              {
                "key": "not_deprecated",
                "name": "Not deprecated",
                "detail": "active, not deprecated or yanked",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "package_not_deprecated",
                    "params": {}
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
      },
      {
        "key": "engineering",
        "band": "moderate",
        "name": "Engineering Quality",
        "value": 59,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "at_risk",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 48,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": false,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "1 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "max_points": 24
              },
              {
                "key": "tests_present",
                "name": "Tests present",
                "detail": null,
                "points": 24,
                "status": "met",
                "details": [],
                "max_points": 24
              },
              {
                "key": "linter_config",
                "name": "Linter config",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 9.6
              },
              {
                "key": "editorconfig",
                "name": ".editorconfig",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.4
              },
              {
                "key": "openssf_scorecard_ci_tests",
                "name": "OpenSSF Scorecard: CI-Tests",
                "detail": "1 out of 11 merged PRs checked by a CI test -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "good",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 75,
            "inputs": {
              "topics": [
                "query-builder",
                "php",
                "mysql",
                "postgresql",
                "microsoft-sql-server",
                "sqlite"
              ],
              "has_wiki": false,
              "homepage": null,
              "has_readme": true,
              "has_docs_dir": true,
              "has_description": true
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 30,
                "status": "met",
                "details": [],
                "max_points": 30
              },
              {
                "key": "documentation_directory",
                "name": "Documentation directory",
                "detail": null,
                "points": 25,
                "status": "met",
                "details": [],
                "max_points": 25
              },
              {
                "key": "documentation_homepage_site",
                "name": "Documentation / homepage site",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              },
              {
                "key": "repository_description",
                "name": "Repository description",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "topics",
                "name": "Topics",
                "detail": "6 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 6
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "at_risk",
        "name": "Security",
        "value": 43,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "at_risk",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Branch-Protection, Packaging, Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "branch_protection",
                    "packaging",
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 43,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 15,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 3,
              "scorecard_aggregate": 4.3
            },
            "components": [
              {
                "key": "binary_artifacts",
                "name": "Binary-Artifacts",
                "detail": "no binaries found in the repo",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "branch_protection",
                "name": "Branch-Protection",
                "detail": "internal error: error during branchesHandler.setup: internal error: some github tokens can't read classic branch protection rules: https://github.com/ossf/scorecard-action/blob/main/docs/authentication/fine-grained-auth-token.md",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "1 out of 11 merged PRs checked by a CI test -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "cii_best_practices",
                "name": "CII-Best-Practices",
                "detail": "no effort to earn an OpenSSF best practices badge detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "code_review",
                "name": "Code-Review",
                "detail": "Found 11/12 approved changesets -- score normalized to 9",
                "points": 6.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 12 contributing companies or organizations",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no dangerous workflow patterns detected",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "dependency_update_tool",
                "name": "Dependency-Update-Tool",
                "detail": "no update tool detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "fuzzing",
                "name": "Fuzzing",
                "detail": "project is not fuzzed",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "license file detected",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "maintained",
                "name": "Maintained",
                "detail": "0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "packaging",
                "name": "Packaging",
                "detail": "packaging workflow not detected",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 5
              },
              {
                "key": "pinned_dependencies",
                "name": "Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "SAST tool is not run on all commits -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "security_policy",
                "name": "Security-Policy",
                "detail": "security policy file not detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "signed_releases",
                "name": "Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "token_permissions",
                "name": "Token-Permissions",
                "detail": "detected GitHub workflow tokens with excessive permissions",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "0 existing vulnerabilities detected",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "high_risk_jurisdiction_exposure",
            "band": "excellent",
            "name": "High-Risk Jurisdiction Exposure",
            "note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
            "notes": [
              {
                "code": "jurisdiction_evidence_limits",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "meaning": "self-published location evidence; not nationality or citizenship",
              "red_flag": false,
              "exposures": [],
              "policy_countries": [
                "Russia",
                "Iran",
                "North Korea"
              ],
              "review_only_matches": 0,
              "assessed_self_published_locations": 18
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "no confirmed policy-scope location match",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "jurisdiction_no_match",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
      },
      {
        "key": "ai_readiness",
        "band": "critical",
        "name": "AI Readiness",
        "value": 27,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "critical",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 19,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.35,
              "agent_instruction_files": [],
              "agent_instruction_max_bytes": null
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "no CLAUDE.md / AGENTS.md / editor rules",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_instructions",
                    "params": {}
                  }
                ],
                "max_points": 45
              },
              {
                "key": "machine_readable_docs_llms_txt",
                "name": "Machine-readable docs (llms.txt)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              },
              {
                "key": "legible_commit_history",
                "name": "Legible commit history",
                "detail": "35 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 18.7,
                "status": "partial",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 35,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "critical",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 22,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [],
              "has_dockerfile": false,
              "typed_language": false,
              "bootstrap_files": [],
              "has_devcontainer": false,
              "has_linter_config": false,
              "typecheck_configs": [],
              "agent_commit_share": 0,
              "toolchain_manifests": [],
              "dependency_bot_commit_share": 0
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 18
              },
              {
                "key": "automated_tests",
                "name": "Automated tests",
                "detail": null,
                "points": 22,
                "status": "met",
                "details": [],
                "max_points": 22
              },
              {
                "key": "lint_format_config",
                "name": "Lint / format config",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "no agent-authored commits among the last 100",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_authored_commits",
                    "params": {
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "automated_maintenance",
                "name": "Automated maintenance",
                "detail": "no automated dependency updates observed",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_dependency_automation",
                    "params": {}
                  }
                ],
                "max_points": 8
              },
              {
                "key": "openssf_scorecard_pinned_dependencies",
                "name": "OpenSSF Scorecard: Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "ai_code_legibility",
            "band": "moderate",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 55,
            "inputs": {
              "primary_language": "PHP",
              "largest_source_bytes": 30633,
              "source_files_sampled": 79,
              "oversized_source_files": 0
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "PHP without a type-check config",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_typecheck_config_language",
                    "params": {
                      "language": "PHP"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "0/79 source files over 60KB",
                "points": 55,
                "status": "met",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 79,
                      "oversized": 0
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          }
        ],
        "description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
      }
    ],
    "metrics_version": "1.13.0"
  },
  "warnings": [
    "Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
    "No resolved dependencies carried a version and a supported ecosystem"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-24T21:33:37.408801Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/a/auraphp/Aura.SqlQuery.svg",
  "full_name": "auraphp/Aura.SqlQuery",
  "license_state": "standard",
  "license_spdx": "MIT"
}

评分是信号,而非担保。 评分反映的是 GitHub 上公开可见的实践——不是代码审计,也不是安全保证。

缺失数据将被剔除并重新归一化权重,绝不按零分计。方法论已版本化并公开:指标 v1.13.0、模式 v0.27.0—— 完整方法论 · 指标知识库.

单项结果在整体记录中的位置: 汇总统计Packagist.