Public record
Software health reportschema 0.27.0 · metrics 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 stars⑂ 87 forkssince Sep 2013View on GitHub ↗

auraphp/Aura.SqlQuery holds a health index of 58 out of 100, placing it in the Moderate band. It scores highest on Sustainability & Governance (74/100) and lowest on AI Readiness (27/100). It was last updated today. 3 contributors account for most of its recent work.

58
overall / 100
Moderate

Software health index

Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At risk ceiling of 49. AI Readiness sits outside the overall score.

58
Excellent85-100Exemplary; meets essentially all checked criteria
Good70-84Healthy; minor gaps
Moderate50-69Acceptable with notable gaps; review recommended
At risk30-49Significant weaknesses; adoption warrants caution
Critical1-29Severe problems (abandoned, single-maintainer, no hygiene)
VitalityCommunity &AdoptionSustainability &GovernanceEngineeringQualitySecurityAI Readiness

Score profile

Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.

Ownership

Aura for PHPOrganization
63 followers41 public repossince Feb 2011

This repository is backed by an organization — shared, accountable stewardship that can outlive any single maintainer.

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
Packagistaura/sqlquery3.0.058,482161186 days agodatabasesqldbmysqlsqlitepostgresqlquerypdopgsqlpostgressql-serversqlserverupdateinsertselectdeletedml

Metrics by category

Vitality

Is the project alive — is code being written and are releases shipping?

43At risk · 22% of overall
How it's scored
36/36Push recency — last push 0 days ago
1.4/36Commit cadence — 2/52 weeks with commits
4.3/18Commit volume — 2 commits in the last year
0/10OpenSSF Scorecard: Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
Inputs used
commits_last_year2
human_commit_share1
days_since_last_push0
active_weeks_last_year2
How it's scored
27/27Ships releases — 16 releases published
0/36Release recency — latest release 1,186 days ago
12.6/27Release cadence — a release every ~328 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count16
latest_release_tag2.8.1
releases_from_tagsno
days_since_latest_release1,186
mean_days_between_releases328
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.

Community & Adoption

Does the project have users, downloads, attention, and a welcoming setup for contributors?

70Good · 18% of overall
How it's scored
43.1/60Stars — 456 stars
16.1/25Forks — 87 forks
8.3/15Watchers — 32 watchers
Inputs used
forks87
stars456
watchers32
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (MIT)
18/18CONTRIBUTING guide
0/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
has_contributingyes
has_issue_templateno
has_code_of_conductno
has_pull_request_templateno
How it's scored
63.6/80Monthly downloads — 58,482 downloads/month across packagist
11/20Registry dependents — 43 packages depend on it
Inputs used
packagesaura/sqlquery
dependents43
ecosystemspackagist
total_downloads3,166,534
monthly_downloads58,482

Sustainability & Governance

Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?

74Good · 24% of overall
How it's scored
36/54Bus factor — 3 contributor(s) cover half of all commits
16.7/22.5Commit distribution — top contributor authored 26% of commits
13.5/13.5Contributor breadth — 36 contributors
10/10OpenSSF Scorecard: Contributors — project has 12 contributing companies or organizations
Inputs used
bus_factor3
contributors_sampled36
top_contributor_share0.259
How it's scored
36.3/46.8Issue resolution — 78% of issues closed
32.4/38.3PR acceptance — 94/111 decided PRs merged
13.5/15OpenSSF Scorecard: Code-Review — Found 11/12 approved changesets -- score normalized to 9
Inputs used
merged_prs94
open_issues22
closed_issues76
issue_closed_ratio0.776
closed_unmerged_prs17
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
13/25Owner reach — 63 followers of auraphp
23.8/25Track record — 41 public repos, account ~15 yr old
Inputs used
followers63
owner_typeOrganization
is_verified
owner_loginauraphp
public_repos41
account_age_days5,642
How it's scored
25/25Published & resolvable — 1 package(s) on packagist
4/35Publish recency — latest publish 1,186 days ago
20/20Version history — 16 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packagesaura/sqlquery
ecosystemspackagist
any_deprecatedno
min_days_since_publish1,186

Engineering Quality

Are baseline engineering and documentation practices in place?

59Moderate · 20% of overall
How it's scored
24/24CI workflows — 1 workflow(s)
24/24Tests present
0/16Linter config
0/9.6Pre-commit hooks
0/6.4.editorconfig
0/20OpenSSF Scorecard: CI-Tests — 1 out of 11 merged PRs checked by a CI test -- score normalized to 0
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configno
has_precommit_configno
How it's scored
30/30README
25/25Documentation directory
0/15Documentation / homepage site
10/10Repository description
10/10Topics — 6 topics
0/10Wiki
Inputs used
topicsquery-builder, php, mysql, postgresql, microsoft-sql-server, sqlite
has_wikino
homepage
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?

43At risk · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — no data
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.5License — 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 — no data
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 — no data
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
7.5/7.5Vulnerabilities — 0 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated15
scorecard_versionv5.5.0
checks_inconclusive3
scorecard_aggregate4.3
Excluded from scoring (no data or not applicable): branch_protection, packaging, signed_releases. Remaining weights renormalized.

AI Readiness

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.

27Critical · 0% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
18.7/40Legible commit history — 35 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
legible_history_share0.35
agent_instruction_files
agent_instruction_max_bytes
How it's scored
0/18One-command bootstrap
22/22Automated tests
0/11Lint / format config
0/11Static type checking
0/10Reproducible environment
0/10Demonstrated agent practice — no agent-authored commits among the last 100
0/8Automated maintenance — no automated dependency updates observed
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfiles
has_dockerfileno
typed_languageno
bootstrap_files
has_devcontainerno
has_linter_configno
typecheck_configs
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
How it's scored
0/45Type-checkable code — PHP without a type-check config
55/55Manageable file sizes — 0/79 source files over 60KB
Inputs used
primary_languagePHP
largest_source_bytes30,633
source_files_sampled79
oversized_source_files0

Key facts

456GitHub stars
36contributors
2commits, last 12 months
0days since last push
16releases
3bus factor
22open issues
Packagistpackage ecosystems

Data collection warnings

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

More detail

Star and fork history 0 ★ / 87 ⇿
0Stars
87Forks
16Releases

When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.

0204060801008362013-102019-052024-12
Major 2Minor 8Patch 4

Each point covers 11 days.

OpenSSF Scorecard 4.3 / 10
4.3aggregate

Independent, tool-agnostic security assessment from the open-source OpenSSF Scorecard. Each check rewards a security practice, not a specific vendor's tool. Checks Scorecard could not determine are marked n/a and excluded from the security score (never counted as zero).Scorecard v5.5.0 · 2026-07-24 21:33 UTC

10Binary-Artifactsno binaries found in the repo
n/aBranch-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
n/aPackagingpackaging 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
n/aSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
10Vulnerabilities0 existing vulnerabilities detected
All dependencies 3

Full resolved dependency set from the GitHub dependency graph: 0 direct and 3 indirect (transitive) packages. The transitive closure is complete when the repository commits a lockfile.

RegistryPackageVersionRelation
Packagistext-pdo_sqliteindirect
Packagistphpindirect
Packagistyoast/phpunit-polyfillsindirect
Dependency advisories not assessed

Advisory matching could not run for this report: No resolved dependencies carried a version and a supported ecosystem

Raw JSON report machine-readable
{
  "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"
}

Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.

Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v1.13.0, schema v0.27.0 — full methodology · metrics wiki.

How one result sits in the wider record: aggregate statisticsPackagist.