Public record
Software health reportschema 0.26.0 · metrics 1.13.0 · 2026-07-22 18:04 UTC

kirschbaum-development / eloquent-power-joins

The Laravel magic you know, now applied to joins.

PHPMIT★ 1,571 stars⑂ 102 forkssince Mar 2020View on GitHub ↗

kirschbaum-development/eloquent-power-joins holds a health index of 63 out of 100, placing it in the Moderate band. It scores highest on Community & Adoption (77/100) and lowest on Security (34/100). It was last updated 54 days ago. A single contributor accounts for most of its recent work.

63
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.

63
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

159 followers49 public repossince Jan 2018

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

Package ecosystems

RegistryPackageVersionDownloads / moVersionsLast publishTags
Packagistkirschbaum-development/eloquent-power-joins4.3.22,922,0887854 days agomysqllaraveljoineloquent

Metrics by category

Vitality

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

60Moderate · 22% of overall
How it's scored
18/36Push recency — last push 54 days ago
5.5/36Commit cadence — 8/52 weeks with commits
9/18Commit volume — 9 commits in the last year
1/10OpenSSF Scorecard: Maintained — 1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1
Inputs used
commits_last_year9
human_commit_share1
days_since_last_push54
active_weeks_last_year8

Release discipline

100Excellent
How it's scored
27/27Ships releases — 71 releases published
36/36Release recency — latest release 54 days ago
27/27Release cadence — a release every ~35.8 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count71
latest_release_tag4.3.2
releases_from_tagsno
days_since_latest_release54
mean_days_between_releases35.8
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?

77Good · 18% of overall
How it's scored
51.8/60Stars — 1,571 stars
16.7/25Forks — 102 forks
8/15Watchers — 28 watchers
Inputs used
forks102
stars1,571
watchers28
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
80/80Monthly downloads — 2,922,088 downloads/month across packagist
10.4/20Registry dependents — 35 packages depend on it
Inputs used
packageskirschbaum-development/eloquent-power-joins
dependents35
ecosystemspackagist
total_downloads34,766,417
monthly_downloads2,922,088

Sustainability & Governance

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

68Moderate · 24% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
4.8/22.5Commit distribution — top contributor authored 79% of commits
13.5/13.5Contributor breadth — 35 contributors
10/10OpenSSF Scorecard: Contributors — project has 4 contributing companies or organizations
Inputs used
bus_factor1
contributors_sampled35
top_contributor_share0.788
How it's scored
43.1/46.8Issue resolution — 92% of issues closed
30.5/38.3PR acceptance — 83/104 decided PRs merged
4.5/15OpenSSF Scorecard: Code-Review — Found 11/30 approved changesets -- score normalized to 3
Inputs used
merged_prs83
open_issues10
closed_issues118
issue_closed_ratio0.922
closed_unmerged_prs21
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
15.8/25Owner reach — 159 followers of kirschbaum-development
24.4/25Track record — 49 public repos, account ~8 yr old
Inputs used
followers159
owner_typeOrganization
is_verified
owner_loginkirschbaum-development
public_repos49
account_age_days3,106
How it's scored
25/25Published & resolvable — 1 package(s) on packagist
35/35Publish recency — latest publish 54 days ago
20/20Version history — 78 published versions
20/20Not deprecated — active, not deprecated or yanked
Inputs used
packageskirschbaum-development/eloquent-power-joins
ecosystemspackagist
any_deprecatedno
min_days_since_publish54

Engineering Quality

Are baseline engineering and documentation practices in place?

71Good · 20% of overall
How it's scored
24/24CI workflows — 2 workflow(s)
24/24Tests present
16/16Linter config — .php-cs-fixer.php
0/9.6Pre-commit hooks
6.4/6.4.editorconfig
8/20OpenSSF Scorecard: CI-Tests — 10 out of 21 merged PRs checked by a CI test -- score normalized to 4
Inputs used
has_ciyes
has_testsyes
has_editorconfigyes
has_linter_configyes
has_precommit_configno

Documentation

60Moderate
How it's scored
30/30README
0/25Documentation directory
0/15Documentation / homepage site
10/10Repository description
10/10Topics — 3 topics
10/10Wiki
Inputs used
topicshacktoberfest, laravel, php
has_wikiyes
homepage
has_readmeyes
has_docs_dirno
has_descriptionyes

Security

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

34At risk · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — branch protection not enabled on development/release branches
1/2.5CI-Tests — 10 out of 21 merged PRs checked by a CI test -- score normalized to 4
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
2.2/7.5Code-Review — Found 11/30 approved changesets -- score normalized to 3
2.5/2.5Contributors — project has 4 contributing companies or organizations
0/10Dangerous-Workflow — no data
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
0.8/7.5Maintained — 1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1
0/5Packaging — no data
0/5Pinned-Dependencies — no data
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 — no data
7.5/7.5Vulnerabilities — 0 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated13
scorecard_versionv5.5.0
checks_inconclusive5
scorecard_aggregate3.4
Excluded from scoring (no data or not applicable): dangerous_workflow, packaging, pinned_dependencies, signed_releases, token_permissions. 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.

53Moderate · 0% of overall
How it's scored
45/45Agent instructions — AGENTS.md
0/15Machine-readable docs (llms.txt)
28.8/40Legible commit history — 54 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
legible_history_share0.54
agent_instruction_filesAGENTS.md
agent_instruction_max_bytes1,115
How it's scored
0/18One-command bootstrap
22/22Automated tests
11/11Lint / format config — .php-cs-fixer.php
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 — no data
Inputs used
has_nixno
has_testsyes
lockfiles
has_dockerfileno
typed_languageno
bootstrap_files
has_devcontainerno
has_linter_configyes
typecheck_configs
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Pinned-Dependencies. Remaining weights renormalized.
How it's scored
0/45Type-checkable code — PHP without a type-check config
55/55Manageable file sizes — 0/58 source files over 60KB
Inputs used
primary_languagePHP
largest_source_bytes35,930
source_files_sampled58
oversized_source_files0

Key facts

1,571GitHub stars
35contributors
9commits, last 12 months
54days since last push
71releases
1bus factor
10open 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 ★ / 102 ⇿
0Stars
102Forks
70Releases

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.

02040608010012010242020-042023-062026-07
Major 3Minor 15Patch 52

Each point covers 6 days.

OpenSSF Scorecard 3.4 / 10
3.4aggregate

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-22 18:04 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
4CI-Tests10 out of 21 merged PRs checked by a CI test -- score normalized to 4
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
3Code-ReviewFound 11/30 approved changesets -- score normalized to 3
10Contributorsproject has 4 contributing companies or organizations
n/aDangerous-Workflowno workflows found
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
1Maintained1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1
n/aPackagingpackaging workflow not detected
n/aPinned-Dependenciesno dependencies found
0SASTSAST tool is not run on all commits -- score normalized to 0
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
n/aToken-PermissionsNo tokens found
10Vulnerabilities0 existing vulnerabilities detected
Direct dependencies 2
RegistryPackageVersion constraintManifest
Packagistilluminate/support^11.42|^12.0|^13.0composer.json
Packagistilluminate/database^11.42|^12.0|^13.0composer.json
All dependencies 7

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

RegistryPackageVersionRelation
Packagistilluminate/databasedirect
Packagistilluminate/supportdirect
Packagistfriendsofphp/php-cs-fixerindirect
Packagistlaravel/legacy-factoriesindirect
Packagistorchestra/testbenchindirect
Packagistphpindirect
Packagistphpunit/phpunitindirect
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": [
        "hacktoberfest",
        "laravel",
        "php"
      ],
      "is_fork": false,
      "size_kb": 603,
      "has_wiki": true,
      "homepage": null,
      "languages": {
        "PHP": 208477
      },
      "pushed_at": "2026-05-28T20:36:23Z",
      "created_at": "2020-03-17T00:32:57Z",
      "owner_type": "Organization",
      "updated_at": "2026-07-21T21:44:48Z",
      "description": "The Laravel magic you know, now applied to joins.",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "master",
      "license_spdx_raw": "MIT",
      "primary_language": "PHP",
      "significant_languages": [
        "PHP"
      ]
    },
    "owner": {
      "blog": "https://kirschbaumdevelopment.com",
      "name": "Kirschbaum Development Group, LLC",
      "type": "Organization",
      "login": "kirschbaum-development",
      "company": null,
      "location": "Northampton, MA",
      "followers": 159,
      "avatar_url": "https://avatars.githubusercontent.com/u/35586907?v=4",
      "created_at": "2018-01-19T03:07:23Z",
      "is_verified": null,
      "public_repos": 49,
      "account_age_days": 3106
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": true
    },
    "activity": {
      "releases": [
        {
          "tag": "4.3.2",
          "kind": "patch",
          "published_at": "2026-05-28T20:36:23Z"
        },
        {
          "tag": "4.3.1",
          "kind": "patch",
          "published_at": "2026-03-29T12:05:30Z"
        },
        {
          "tag": "4.3.0",
          "kind": "minor",
          "published_at": "2026-03-17T16:43:27Z"
        },
        {
          "tag": "4.2.11",
          "kind": "patch",
          "published_at": "2025-12-17T00:38:10Z"
        },
        {
          "tag": "4.2.10",
          "kind": "patch",
          "published_at": "2025-11-13T14:58:23Z"
        },
        {
          "tag": "4.2.9",
          "kind": "patch",
          "published_at": "2025-10-25T11:39:34Z"
        },
        {
          "tag": "4.2.8",
          "kind": "patch",
          "published_at": "2025-08-14T18:43:30Z"
        },
        {
          "tag": "4.2.7",
          "kind": "patch",
          "published_at": "2025-08-06T10:46:36Z"
        },
        {
          "tag": "4.2.6",
          "kind": "patch",
          "published_at": "2025-07-10T16:55:51Z"
        },
        {
          "tag": "4.2.5",
          "kind": "patch",
          "published_at": "2025-07-10T15:27:08Z"
        },
        {
          "tag": "4.2.4",
          "kind": "patch",
          "published_at": "2025-05-19T14:15:00Z"
        },
        {
          "tag": "4.2.3",
          "kind": "patch",
          "published_at": "2025-04-01T14:42:15Z"
        },
        {
          "tag": "4.2.2",
          "kind": "patch",
          "published_at": "2025-03-08T01:26:21Z"
        },
        {
          "tag": "4.2.1",
          "kind": "patch",
          "published_at": "2025-03-05T10:11:54Z"
        },
        {
          "tag": "4.2.0",
          "kind": "minor",
          "published_at": "2025-02-13T23:30:54Z"
        },
        {
          "tag": "4.1.0",
          "kind": "minor",
          "published_at": "2025-02-12T11:14:57Z"
        },
        {
          "tag": "4.0.1",
          "kind": "patch",
          "published_at": "2024-11-26T13:22:27Z"
        },
        {
          "tag": "4.0.0",
          "kind": "major",
          "published_at": "2024-10-06T12:34:28Z"
        },
        {
          "tag": "3.5.8",
          "kind": "patch",
          "published_at": "2024-09-10T10:28:25Z"
        },
        {
          "tag": "3.5.7",
          "kind": "patch",
          "published_at": "2024-06-26T13:11:09Z"
        },
        {
          "tag": "3.5.6",
          "kind": "patch",
          "published_at": "2024-04-09T00:35:55Z"
        },
        {
          "tag": "3.5.5",
          "kind": "patch",
          "published_at": "2024-03-27T11:14:31Z"
        },
        {
          "tag": "3.5.4",
          "kind": "patch",
          "published_at": "2024-03-26T19:21:08Z"
        },
        {
          "tag": "3.5.3",
          "kind": "patch",
          "published_at": "2024-03-26T10:43:58Z"
        },
        {
          "tag": "3.5.2",
          "kind": "patch",
          "published_at": "2024-03-20T10:23:43Z"
        },
        {
          "tag": "3.5.1",
          "kind": "patch",
          "published_at": "2024-03-19T22:46:06Z"
        },
        {
          "tag": "3.5.0",
          "kind": "minor",
          "published_at": "2024-02-13T15:40:41Z"
        },
        {
          "tag": "3.4.0",
          "kind": "minor",
          "published_at": "2023-12-07T10:45:10Z"
        },
        {
          "tag": "3.3.4",
          "kind": "patch",
          "published_at": "2023-12-07T10:39:55Z"
        },
        {
          "tag": "3.3.3",
          "kind": "patch",
          "published_at": "2023-10-31T18:02:25Z"
        },
        {
          "tag": "3.3.2",
          "kind": "patch",
          "published_at": "2023-10-29T00:53:20Z"
        },
        {
          "tag": "3.3.1",
          "kind": "patch",
          "published_at": "2023-10-28T13:49:05Z"
        },
        {
          "tag": "3.3.0",
          "kind": "minor",
          "published_at": "2023-10-22T13:04:40Z"
        },
        {
          "tag": "3.2.4",
          "kind": "patch",
          "published_at": "2023-09-12T17:07:54Z"
        },
        {
          "tag": "3.2.3",
          "kind": "patch",
          "published_at": "2023-09-04T10:22:18Z"
        },
        {
          "tag": "3.2.2",
          "kind": "patch",
          "published_at": "2023-08-28T10:27:36Z"
        },
        {
          "tag": "3.2.1",
          "kind": "patch",
          "published_at": "2023-07-30T02:16:23Z"
        },
        {
          "tag": "3.2.0",
          "kind": "minor",
          "published_at": "2023-06-25T11:42:28Z"
        },
        {
          "tag": "3.1.1",
          "kind": "patch",
          "published_at": "2023-06-20T13:50:44Z"
        },
        {
          "tag": "3.1.0",
          "kind": "minor",
          "published_at": "2023-06-15T10:44:47Z"
        },
        {
          "tag": "3.0.3",
          "kind": "patch",
          "published_at": "2023-06-04T12:21:20Z"
        },
        {
          "tag": "3.0.2",
          "kind": "patch",
          "published_at": "2023-03-16T14:41:57Z"
        },
        {
          "tag": "3.0.1",
          "kind": "patch",
          "published_at": "2023-03-07T15:59:05Z"
        },
        {
          "tag": "3.0.0",
          "kind": "major",
          "published_at": "2023-03-05T12:22:03Z"
        },
        {
          "tag": "2.7.3",
          "kind": "patch",
          "published_at": "2023-03-05T11:19:55Z"
        },
        {
          "tag": "2.7.2",
          "kind": "patch",
          "published_at": "2023-02-08T11:00:04Z"
        },
        {
          "tag": "2.7.1",
          "kind": "patch",
          "published_at": "2023-02-05T11:15:25Z"
        },
        {
          "tag": "2.7.0",
          "kind": "minor",
          "published_at": "2023-01-23T11:04:52Z"
        },
        {
          "tag": "2.6.5",
          "kind": "patch",
          "published_at": "2022-12-09T10:31:51Z"
        },
        {
          "tag": "2.6.4",
          "kind": "patch",
          "published_at": "2022-04-06T22:58:53Z"
        },
        {
          "tag": "2.6.3",
          "kind": "patch",
          "published_at": "2022-03-05T19:16:22Z"
        },
        {
          "tag": "2.6.2",
          "kind": "patch",
          "published_at": "2022-03-05T18:40:14Z"
        },
        {
          "tag": "2.6.1",
          "kind": "patch",
          "published_at": "2022-02-15T01:13:46Z"
        },
        {
          "tag": "2.6.0",
          "kind": "minor",
          "published_at": "2022-02-09T13:37:42Z"
        },
        {
          "tag": "2.5.2",
          "kind": "patch",
          "published_at": "2022-02-06T13:13:13Z"
        },
        {
          "tag": "2.5.1",
          "kind": "patch",
          "published_at": "2021-11-18T17:09:34Z"
        },
        {
          "tag": "2.5.0",
          "kind": "minor",
          "published_at": "2021-10-24T23:01:30Z"
        },
        {
          "tag": "2.4.1",
          "kind": "patch",
          "published_at": "2021-08-30T10:20:15Z"
        },
        {
          "tag": "2.4.0",
          "kind": "minor",
          "published_at": "2021-04-18T22:41:13Z"
        },
        {
          "tag": "2.3.3",
          "kind": "patch",
          "published_at": "2021-04-07T12:22:10Z"
        },
        {
          "tag": "2.3.2",
          "kind": "patch",
          "published_at": "2020-12-29T19:21:24Z"
        },
        {
          "tag": "2.3.1",
          "kind": "patch",
          "published_at": "2020-12-22T16:03:12Z"
        },
        {
          "tag": "2.3.0",
          "kind": "minor",
          "published_at": "2020-11-28T15:07:08Z"
        },
        {
          "tag": "2.2.3",
          "kind": "patch",
          "published_at": "2020-10-30T18:46:37Z"
        },
        {
          "tag": "2.2.2",
          "kind": "patch",
          "published_at": "2020-10-24T01:05:14Z"
        },
        {
          "tag": "2.2.1",
          "kind": "patch",
          "published_at": "2020-10-14T19:26:38Z"
        },
        {
          "tag": "2.2.0",
          "kind": "minor",
          "published_at": "2020-10-09T00:38:30Z"
        },
        {
          "tag": "2.1.0",
          "kind": "minor",
          "published_at": "2020-09-10T23:50:51Z"
        },
        {
          "tag": "2.0.0",
          "kind": "major",
          "published_at": "2020-08-30T14:37:30Z"
        },
        {
          "tag": "1.1.1",
          "kind": "patch",
          "published_at": "2020-05-14T22:14:18Z"
        },
        {
          "tag": "1.1.0",
          "kind": "minor",
          "published_at": "2020-04-13T13:26:19Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "33c189bd51a510c1ceba67222395ead08a29863a",
          "body": "performJoinForEloquentPowerJoinsForMorph used $this->parent->getTable()\ndirectly, ignoring any alias set via StaticCache. All other join methods\nalready use StaticCache::getTableOrAliasForModel($this->parent) for this.\n\nCo-authored-by: Marick van Tuil <marick@dolphiq.nl>",
          "is_bot": false,
          "headline": "bugfix: use parent table alias in MorphOneOrMany join (#236)",
          "author_name": "Marick van Tuil",
          "author_login": "marickvantuil",
          "committed_at": "2026-05-28T20:35:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3f77b096c1e8b5aa1fc40d7080e55e795f3430ae",
          "body": "* Added failing test\n\n* Fix joinRelationship overriding columns passed to get()/first()\n\nDefer the default select('table.*') to a beforeQuery callback so it\nonly fires when no explicit columns have been set by query execution\ntime. This allows columns passed to get()/first() to take precedence\nvia L\n[…]\nchanism.\n\nAlso adds explicit select guards in orderByPowerJoins and\nperformHavingForEloquentPowerJoins which use selectRaw internally\nand need the base table columns present.\n\nFixes #229\n\n* Code style",
          "is_bot": false,
          "headline": "Fix joinRelationship overriding columns in get()/first() (#233)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2026-03-29T12:05:03Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "dbf2dfaa1900152f2e3dc42b30b67f67a82e7c36",
          "body": "* because we don't want to version idea\n\n* laravel 13 support\n\n* bump legacy factories\n\n* Fix CI failures for PHPUnit 12 and PHP-CS-Fixer\n- Remove unnecessary else after return in PowerJoinClause::where\n- Add test_ prefix to LaravelScopeAttributeTest method (PHPUnit 12 dropped @test annotation discovery)\n- Update phpunit.xml.dist to use PHPUnit 10+ config format",
          "is_bot": false,
          "headline": "Laravel 13 support (#232)",
          "author_name": "Babacar Cissé Dia",
          "author_login": "babacarcissedia",
          "committed_at": "2026-03-17T16:43:01Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0e3e3372992e4bf82391b3c7b84b435c3db73588",
          "body": null,
          "is_bot": false,
          "headline": "Added PHP 8.5 support (#227)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-12-17T00:37:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a42cf9d6ab7f8c39e46056832d86b727643f8f89",
          "body": "* Added failing test\n\n* Fixed fromRaw\n\n* Fixed tests",
          "is_bot": false,
          "headline": "Fix: TypeError with fromRaw() when using alias from 'from' method (#226)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-12-17T00:30:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ccda351a75701f5b0a6f94586d9a40f1114302b4",
          "body": "* Added a failing test\n\n* Fixed usage of alias coming from the 'from' method",
          "is_bot": false,
          "headline": "Using alias from the 'from' method when set (#224)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-11-13T14:57:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "32ec75ffee5f8f66e2c95e4030fa0b2454e51048",
          "body": "…able twice (#222)",
          "is_bot": false,
          "headline": "fix alias not applying in \"through\" joins when referencing the same t…",
          "author_name": "Henrik",
          "author_login": "henrik0804",
          "committed_at": "2025-10-25T11:39:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d67c7e2efa886d2ef8bb29e86c3ddb9438ac6390",
          "body": "* Update .gitattributes\n\n* Update .gitattributes",
          "is_bot": false,
          "headline": "Exclude files (#221)",
          "author_name": "Bert",
          "author_login": "bert-w",
          "committed_at": "2025-08-14T18:43:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f2f8d3575a54d91b3e5058d65ac1fccb3ea7dd94",
          "body": "…s (#217)\n\n* Added failing test\n\n* Added ability to call scoped method via attributes\n\n* Removed FKs 🤢\n\n* Made method public\n\n* wip",
          "is_bot": false,
          "headline": "Add support for Laravel scope attributes in joinRelationship callback…",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-08-06T10:46:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "72cff1e838bb3f826dc09a5566219ad7fa56237f",
          "body": "…e times (#214)\n\n* Fix duplicate alias generation when joining same relationship multiple times\n\nReplace time() with uniqid() in generateAliasForRelationship() to ensure unique aliases are generated even when called multiple times within the same second. This prevents later joins from overwriting ea\n[…]\n Fix test to be database-agnostic for MySQL compatibility\n\nUpdate alias count check to handle both double quotes (PostgreSQL/SQLite) and backticks (MySQL) when counting table aliases in generated SQL.",
          "is_bot": false,
          "headline": "Fix duplicate alias generation when joining same relationship multipl…",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-07-10T16:55:34Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "96e1a061ab97f36afb8ccfcd6c02b07f702d36e6",
          "body": "…(#213)\n\n* Added failing test\n\n* Fix latestOfMany relationships using wrong foreign key in subqueries\n\nWhen using leftJoinRelationship with latestOfMany relationships that have custom foreign keys, the generated subquery was incorrectly using the parent model's primary key instead of the relationshi\n[…]\n[opencode](https://opencode.ai)\n\nCo-Authored-By: opencode <noreply@opencode.ai>\n\n* wip\n\n* Changed min stability to stable\n\n* Fixed code style\n\n---------\n\nCo-authored-by: opencode <noreply@opencode.ai>",
          "is_bot": false,
          "headline": "Fix latestOfMany relationships using wrong foreign key in subqueries …",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-07-10T15:26:42Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "63f0aeb6301488ab9956f2d38d168b8bdeee0aff",
          "body": null,
          "is_bot": false,
          "headline": "Run tests",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-07-09T16:07:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4a8012cef7abed8ac3633a180c69138a228b6c4c",
          "body": "…s (#210)\n\nCo-authored-by: Marick van Tuil <marick@dolphiq.nl>",
          "is_bot": false,
          "headline": "Correct 'through' relation alias, add missing alias to morph relation…",
          "author_name": "Marick van Tuil",
          "author_login": "marickvantuil",
          "committed_at": "2025-05-19T14:14:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d04e06b12e5e7864c303b8a8c6045bfcd4e2c641",
          "body": null,
          "is_bot": false,
          "headline": "Merging casts when cloning (#208)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-04-01T14:41:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f91ef1b6311d7cccbec20cd08ed6250f07cd98d8",
          "body": null,
          "is_bot": false,
          "headline": "Updating to use L12 stable version",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-04-01T11:29:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a307fab78c291526fba754e6ac8a86f7bd58d45d",
          "body": "* Fix alias not fully applying in has one/many through\n\n* Fix tes\n\n---------\n\nCo-authored-by: Marick van Tuil <marick@Mac.home>",
          "is_bot": false,
          "headline": "Fix alias not fully applying in has one/many through (#205)",
          "author_name": "Marick van Tuil",
          "author_login": "marickvantuil",
          "committed_at": "2025-03-08T01:26:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "84a24784d9abde8bafb1998a0841a6bc10fa6f8e",
          "body": "* add failing test case\n\n* do not skip soft delete wheres when using alias\n\n* fix tests\n\n* linter",
          "is_bot": false,
          "headline": "fix: include soft delete conditions when using named aliases (#204)",
          "author_name": "luisvdbk",
          "author_login": "luisvdbk",
          "committed_at": "2025-03-05T10:11:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b092366fd69edd81da8b1b7da73160ff18806d8a",
          "body": null,
          "is_bot": false,
          "headline": "Update README.md",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-02-27T11:08:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "aafbe349e0ad4862273880652d0141bb753c4fc7",
          "body": "* Testing on Laravel 12\r\n\r\n* wip\r\n\r\n* wip\r\n\r\n* wip",
          "is_bot": false,
          "headline": "Laravel 12 official support (#203)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-02-13T23:30:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ee219efc978803726633299b952d2b23b8bcbbd0",
          "body": "* Fix relationship already joined cache\r\n\r\n* Revert \"Fix relationship already joined cache\"\r\n\r\nThis reverts commit ed09eea525a55f357ef00c662f60f9041dac061f.\r\n\r\n* WIP\r\n\r\n* Working WIP\r\n\r\n* Working\r\n\r\n* WIP\r\n\r\n* Update JoinRelationshipTest.php\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n*\n[…]\nw\r\n\r\n* WIP\r\n\r\n* Update JoinsHelper.php\r\n\r\n* WIP\r\n\r\n* Update JoinsHelper.php\r\n\r\n* Executing the queries to make sure they work in tests\r\n\r\n---------\r\n\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>",
          "is_bot": false,
          "headline": "Fix: relationship join cache with query clones (#202)",
          "author_name": "Ralph J. Smit",
          "author_login": "ralphjsmit",
          "committed_at": "2025-02-13T23:18:28Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "d6c5cb1b90c0bd033a8f9159a78fd6a23e9ac5c2",
          "body": "* Fix relatedKey for BelongsToMany relationship\r\n\r\n* Add slugPosts relationship and related tests for Group model\r\n\r\n* Change post_slug column type from unsignedInteger to string in post_groups_slug table\r\n\r\n---------\r\n\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>",
          "is_bot": false,
          "headline": "Fix relatedKey for BelongsToMany relationship (#196)",
          "author_name": "Kadir Gün",
          "author_login": "kadirgun",
          "committed_at": "2025-02-12T11:14:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cc592470ece5faf556cd73d3622698273e28de02",
          "body": "* Updated CI config\r\n\r\n* Updated cache version\r\n\r\n* Added --default-authentication-plugin=mysql_native_password to MySQL\r\n\r\n* Revert that\r\n\r\n* wip\r\n\r\n* Removing PHP 8.1\r\n\r\n* Added php 8.4\r\n\r\n* Added Laravel 12",
          "is_bot": false,
          "headline": "Update CI config; PHP 8.4 full support; (#201)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-02-11T20:36:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "aeaf359c06ac850dd0de07d8fc4dd15b09e98737",
          "body": null,
          "is_bot": false,
          "headline": "Updated CI config",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2025-02-11T18:47:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "98bb3eb24e7a28792ed3c6e07e2df69588f707c3",
          "body": null,
          "is_bot": false,
          "headline": "fix: typo in docs (#199)",
          "author_name": "Daniel",
          "author_login": "danielgnh",
          "committed_at": "2025-02-05T14:02:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3c1af9b86b02f1e39219849c1d2fee7cf77e8638",
          "body": "… #191 (#192)",
          "is_bot": false,
          "headline": "Add extra condition to avoid wrong on clause on MorphTo joins, closes…",
          "author_name": "Sébastien JEAN",
          "author_login": "sebj54",
          "committed_at": "2024-11-26T13:22:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a01958a522d4a0e5e84bbb7ccf008c8c83f904b7",
          "body": null,
          "is_bot": false,
          "headline": "Temporary revert",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-11-17T19:55:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bd8681969b4b79a370f41e2ed0a4bf69f5abbe4e",
          "body": null,
          "is_bot": false,
          "headline": "Using the actual php version on tests",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-10-21T17:09:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c6c42a52c5a097cc11761e72782b2d0215692caf",
          "body": null,
          "is_bot": false,
          "headline": "Removed deprecated methods from stubs",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-10-06T12:28:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "470a34eaa59b6bc633653ddf6d26d204cba39716",
          "body": null,
          "is_bot": false,
          "headline": "Code style adjustments",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-10-06T12:26:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "13308c00f26527234ef6be32ff2968dcdf5f2451",
          "body": null,
          "is_bot": false,
          "headline": "Updated readme",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-10-06T12:19:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3da344597a09107ffa7f655f10b1dec075e7f5d4",
          "body": null,
          "is_bot": false,
          "headline": "Adjusted stubs",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-10-06T12:17:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "98127656bad90c580500b58e9321e715a619f9d8",
          "body": null,
          "is_bot": false,
          "headline": "Types and stubs",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-10-03T14:13:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "013c4fef432345b751a6b3da941b80070146ec3b",
          "body": "feat: add cs fixer",
          "is_bot": false,
          "headline": "Merge pull request #165 from GeoSot/feat/gs/add-cs-fixer",
          "author_name": "Dan Harrin",
          "author_login": "danharrin",
          "committed_at": "2024-10-02T20:31:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "257ddeebad43410d27fb954a99ec8ccb59e01b9f",
          "body": null,
          "is_bot": false,
          "headline": "Run formatter",
          "author_name": "Dan Harrin",
          "author_login": "danharrin",
          "committed_at": "2024-10-02T20:29:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "03257fb04dbbe3b75915e44f61151053c8e6ef4f",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch 'master' into pr/165",
          "author_name": "Dan Harrin",
          "author_login": "danharrin",
          "committed_at": "2024-10-02T20:27:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "090faa7c46a96a372fa45f3a8d2b31aaa5a8fa4e",
          "body": null,
          "is_bot": false,
          "headline": "Update .php-cs-fixer.php",
          "author_name": "Dan Harrin",
          "author_login": "danharrin",
          "committed_at": "2024-10-02T20:27:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ae86d14abd4f9c3498c7b2206fa54a5d93509815",
          "body": null,
          "is_bot": false,
          "headline": "add config file on ci",
          "author_name": "GeoSot",
          "author_login": "GeoSot",
          "committed_at": "2024-10-02T20:26:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f2cd0af3e2918547c127ba7ea6a1ba455d027d69",
          "body": null,
          "is_bot": false,
          "headline": "add config file on ci",
          "author_name": "GeoSot",
          "author_login": "GeoSot",
          "committed_at": "2024-10-02T20:26:49Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a5ee29cae5cb24fac91642c8224388977b5f5dba",
          "body": "* Update README.md\r\n\r\nDocumentation for join type in joinRelationship()\r\n\r\n* Possibility to indicate join type for each relation in joinRelationship callbacks:\r\n\r\n User::joinRelationship('posts.comments', [\r\n    'posts' => function ($join) {\r\n        $join->where('posts.published', true);\r\n    },\r\n \n[…]\no be changed for pull request.\r\n\r\n* Code style\r\n\r\n* Fixed tests\r\n\r\n* Removed test\r\n\r\n---------\r\n\r\nCo-authored-by: Dima Kamynin <dima@ociohoteles.com>\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>",
          "is_bot": false,
          "headline": "Join type in nested sub-relations (#104)",
          "author_name": "dmikam",
          "author_login": "dmikam",
          "committed_at": "2024-10-02T20:15:40Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "3e820ba0a406f3913872c14927ce77b37462503a",
          "body": "* Allow to join nested MorphTo relations\r\n\r\n* Add test for joining nested MorphTo relations",
          "is_bot": false,
          "headline": "Allow to join nested MorphTo relations (#180)",
          "author_name": "Aztek-Johan",
          "author_login": "Aztek-Johan",
          "committed_at": "2024-10-02T19:51:25Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a0d2aec84abb03bc75b47163abd79fc498641665",
          "body": "* wip\r\n\r\n* wip\r\n\r\n* Update OrderByTest.php\r\n\r\n* Fixed hasOneOfMany for MySQL and Postgres\r\n\r\n* Removed readme\r\n\r\n* Handling left joins in one of many\r\n\r\n* Add phpunit.xml to gitignore\r\n\r\n* Remove support for unsupported PHP/Laravel versions\r\n\r\n* Remove DB setup in test case\r\n\r\n* Add CI jobs for test\n[…]\nate JoinRelationshipTest.php\r\n\r\n* Update 2020_03_16_000000_create_tables.php\r\n\r\n* Dropped PowerJoins trait\r\n\r\n* Removed PowerJoins traits\r\n\r\n---------\r\n\r\nCo-authored-by: Dan Harrin <git@danharrin.com>",
          "is_bot": false,
          "headline": "Enhance and test support for PostgreSQL (#189)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-10-02T19:46:23Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "397ef08f15ceff48111fd7f57d9f1fd41bf1a453",
          "body": null,
          "is_bot": false,
          "headline": "Support HasOneThrough (#187)",
          "author_name": "Amando",
          "author_login": "AmandoVledder",
          "committed_at": "2024-09-10T10:28:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "aeae41d6600dea972e9e6dc2bdb8812c787e7567",
          "body": "The link to the more detailed blog post is broken as the link has changed.",
          "is_bot": false,
          "headline": "Update README.md (#185)",
          "author_name": "Richard Howes",
          "author_login": "richardhowes",
          "committed_at": "2024-07-10T21:13:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3f57b398117d97bae4dfd5c37ea0f8f48f296c97",
          "body": "…rectly (#183)",
          "is_bot": false,
          "headline": "Using model scopes instead of checking the soft delete scope trait di…",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-06-26T13:09:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6de51d9ec43af34e77bd1d9908173de1416a0aed",
          "body": null,
          "is_bot": false,
          "headline": "Added calling of the queries to ensure test coverage",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-04-09T00:35:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c430a7705e837faab5eeaca49c90650c28c2387e",
          "body": null,
          "is_bot": false,
          "headline": "Allow pass relationship aliases to orderByPowerJoins (#179)",
          "author_name": "Luis Andrés Arce C",
          "author_login": "luilliarcec",
          "committed_at": "2024-04-09T00:31:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1c656e69f04600f8360010bedd87d489d3e417cd",
          "body": null,
          "is_bot": false,
          "headline": "Update README.md",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-03-27T11:17:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ed5af4788f0dad3ce35bb883cecac4293496139a",
          "body": null,
          "is_bot": false,
          "headline": "Set model in eloquent builder",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-03-27T11:14:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fc8bb379f062cd120ffab20a6913ad824c3366d8",
          "body": "…the joins",
          "is_bot": false,
          "headline": "Added the ability to call methods from custom eloquent builders from …",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-03-26T19:12:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4b948b1682ef565aa367e3a651ae69fe37b0f400",
          "body": null,
          "is_bot": false,
          "headline": "Replacing dots in table definition alias to avoid issues with postgres",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-03-26T10:38:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2fae3aca9eefd4591603a7e53406ab9f56b69fad",
          "body": "…: 7 ERROR\" #172 (#174)",
          "is_bot": false,
          "headline": "Fixed: Upgrading from 3.2.1 to 3.5.0 produces error \"Undefined column…",
          "author_name": "Vedmant",
          "author_login": "vedmant",
          "committed_at": "2024-03-20T10:23:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "571f09c4b23c349cb1a5db8bb88af291ed30389c",
          "body": null,
          "is_bot": false,
          "headline": "fix: allow non nested joins to specify pivot information (#173)",
          "author_name": "Alexandru Bucur",
          "author_login": "CoolGoose",
          "committed_at": "2024-03-19T22:45:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "01e70ed600570d7b91d1f21f445b2890e7b753d6",
          "body": null,
          "is_bot": false,
          "headline": "Update README.md",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-03-01T19:48:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "13feb3692ab6c0475b2c05de131d5f5822fb250a",
          "body": "* Laravel 11 support\r\n\r\n* wip",
          "is_bot": false,
          "headline": "Laravel 11 support (#169)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2024-02-13T15:40:14Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9238fcb53d777265ee9d8d139810e2cadecde079",
          "body": null,
          "is_bot": false,
          "headline": "PHP 8.3 support (#166)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-12-07T10:44:41Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4718c937275e8a2428976cffd341a598ab420d2a",
          "body": null,
          "is_bot": false,
          "headline": "Making sure PowerJoinClause can be type-hinted",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-12-07T10:38:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "06ab09cea917d0ff1ddee9ce24f186d6158f7ad7",
          "body": null,
          "is_bot": false,
          "headline": "feat: add cs fixer",
          "author_name": "GeoSot",
          "author_login": "GeoSot",
          "committed_at": "2023-11-02T10:52:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e55fa70dfa4a5e897443454825b9d4ce6081786a",
          "body": "* Fixes to avoid passing null values to qualiyColumn method\r\n\r\n* Fixed test\r\n\r\n* Removed debug code",
          "is_bot": false,
          "headline": "Issue 160: Avoid calling internal methods with `null` (#164)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-10-31T18:01:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9ffa7d4f9e50f427e751f0cb5a090f3433ed5c6c",
          "body": null,
          "is_bot": false,
          "headline": "Removed trait PowerJoins set up",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-10-30T19:47:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "260f8d24306ec1731bd270104f0bc3655c4dbd32",
          "body": null,
          "is_bot": false,
          "headline": "Added ability to use array callbacks in nested powerJoinWhereHas (#163)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-10-29T00:53:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "52a1282c0938fd5396a7bf970e6a0a8c56c8f560",
          "body": "* Added support for powerJoinHas with MorphTo relationships\r\n\r\n* Readme addition",
          "is_bot": false,
          "headline": "Added support for powerJoinHas with MorphTo relationships (#162)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-10-28T13:48:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2cb2d8763d55ef9d1e7362232d1404681cc8e895",
          "body": null,
          "is_bot": false,
          "headline": "Removed unused function",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-10-26T22:48:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9dd336b17cca5c82315365c5323895297fc35037",
          "body": null,
          "is_bot": false,
          "headline": "Added support for morphTo (#158)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-10-22T13:00:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d1054e647e45fd21afbe483212b47ce288cb1705",
          "body": null,
          "is_bot": false,
          "headline": "Fixed test name",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-09-12T20:24:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fadc20d436b0693a34c4b611d07954818e46eb4d",
          "body": null,
          "is_bot": false,
          "headline": "Clear the joins cache before starting a join",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-09-12T17:02:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e9d936e0071d47796735b40ed6cce5dfd0a4305d",
          "body": null,
          "is_bot": false,
          "headline": "Update RelationshipsExtraMethods.php (#154)",
          "author_name": "s-7777",
          "author_login": "s-7777",
          "committed_at": "2023-09-04T10:21:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "23650f7707e25190511ab15b22a95e3a32ad277b",
          "body": null,
          "is_bot": false,
          "headline": "Change alias generation for aggregate sort functions (#152)",
          "author_name": "Luis Andrés Arce C",
          "author_login": "luilliarcec",
          "committed_at": "2023-08-28T10:27:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e92329b3d89c0e56e0ae32ba76e332f1848769a0",
          "body": null,
          "is_bot": false,
          "headline": "Fixed clone of queries that were duplicating joins",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-07-30T02:14:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ef388b6b6ae1502fac172b8beb6f13ffe541569b",
          "body": "* Added support for hasOne()->ofMany()\r\n\r\n* Improved tests; Added additional check:",
          "is_bot": false,
          "headline": "Feature: Has one of many support (#141)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-06-25T11:42:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f8187582bcc87e951c91ed2e07fd53c3182a98f6",
          "body": "* ref: add `as` method docblock to FakeJoinCallback\r\n\r\n* ref: add StaticCache methods and make consistent usage of them",
          "is_bot": false,
          "headline": "Ref: use methods accessing StaticCache (#139)",
          "author_name": "GeoSot",
          "author_login": "GeoSot",
          "committed_at": "2023-06-25T11:06:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "24af544ca28dd3300e9ee74e4b041da01818c4b1",
          "body": null,
          "is_bot": false,
          "headline": "feat: support for statically added closure global scopes (#140)",
          "author_name": "Billy",
          "author_login": null,
          "committed_at": "2023-06-20T13:50:15Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0eb823dd3e5630acabd89caae2c8df4c1fd7bfb7",
          "body": "Co-authored-by: Bruno Lopes <bruno.lrocha@americanas.io>",
          "is_bot": false,
          "headline": "adds where has belongs to many test (#138)",
          "author_name": "Bruno Lopes",
          "author_login": "lopesrbruno",
          "committed_at": "2023-06-19T19:52:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e20600bcf0bcd978888baf0bfcf5edd4ebbe8842",
          "body": "Co-authored-by: Bruno Lopes <bruno.lrocha@americanas.io>",
          "is_bot": false,
          "headline": "fix morph to many (#137)",
          "author_name": "brunolopesr",
          "author_login": "lopesrbruno",
          "committed_at": "2023-06-15T10:43:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7b4c6b7b9977fd9ca98b7403dadfcda3bd93434f",
          "body": "* ref: Move PowerJoins Trait to JoinRelationship Mixin\r\n\r\n* fix(caching): each builder instance must have its own cache",
          "is_bot": false,
          "headline": "Move PowerJoins Trait to JoinRelationship Mixin (#135)",
          "author_name": "GeoSot",
          "author_login": "GeoSot",
          "committed_at": "2023-06-15T10:41:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "85ff7684a25049aee6a1c9e26a751ce5be60d6d9",
          "body": null,
          "is_bot": false,
          "headline": "Fixed morph relationships using alias",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-06-04T12:19:28Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b9aa4c2364e2776e5aacca49160d4b519ae82768",
          "body": "…n name (#127)\n\n* Fix many to many nested\r\n\r\n* check with dots if is already replaced\r\n\r\n---------\r\n\r\nCo-authored-by: Alex Osendi <alejandro.osendi@doubledot.es>",
          "is_bot": false,
          "headline": "Fix nested many to many alias, allow callbacks using the full relatio…",
          "author_name": "Runig006",
          "author_login": "Runig006",
          "committed_at": "2023-03-16T14:41:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6b312354b99695d864edad2fc4aeeb0cdaf30128",
          "body": "…onship",
          "is_bot": false,
          "headline": "Fixed join of multiple nested relationships with the same base relati…",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-03-07T15:57:57Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "92ce06ef916c5426fa6c8d3c6692a17b1112e3ff",
          "body": "* Updated version compatibility\r\n\r\n* Fixed usage of ->as alias on BelongsToMany relationships",
          "is_bot": false,
          "headline": "Fixed usage of ->as alias on BelongsToMany relationships (#124)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-03-05T12:21:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "14eb8de38e30ce8f7323beb45800673467567f56",
          "body": "* wip\r\n\r\n* wip\r\n\r\n* wip\r\n\r\n* wip",
          "is_bot": false,
          "headline": "Fix tests by using Composer v2 (#123)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-03-05T11:19:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f02079962b0bd48a39ffc4980c30fc7748cc9289",
          "body": null,
          "is_bot": false,
          "headline": "Updated test versions",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-03-02T18:04:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "179ed3ba61bcd37ebd5711e1fc01c46569631b95",
          "body": null,
          "is_bot": false,
          "headline": "Using composer v2",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-03-02T18:03:36Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "76f6ed5844af2dc1bafef251398d488fdf992841",
          "body": null,
          "is_bot": false,
          "headline": "Update PowerJoinClause.php (#122)",
          "author_name": "Runig006",
          "author_login": "Runig006",
          "committed_at": "2023-03-02T17:59:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "9db3de5c4be225d9fd19676c4219ec39c4d0e003",
          "body": "* Fixes for nested where conditions in join clauses\r\n\r\n* Fixed other use cases",
          "is_bot": false,
          "headline": "Fixes for nested where conditions in join clauses (#119)",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-02-08T10:57:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "54c290c932e9f6bc41d4a8bc330de67456fb306f",
          "body": null,
          "is_bot": false,
          "headline": "Code style adjustments",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-02-05T11:14:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f620a93350953543a67909f1536e6e39240afbd5",
          "body": "* Encapsulate nested conditions inside a where function\r\n\r\n* More complex nested condition test",
          "is_bot": false,
          "headline": "Encapsultate nested conditions inside a where statement (#116)",
          "author_name": "toyi",
          "author_login": "toyi",
          "committed_at": "2023-02-05T11:13:09Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "be1b04e754db238e0e07a18ae595cd7594c68a1d",
          "body": null,
          "is_bot": false,
          "headline": "Added Laravel 10 support",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2023-01-23T11:00:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b3c95fc63535c59a7fb98ea3e86947078f3f3154",
          "body": "* Laravel 10.x support\r\n\r\n* exclude laravel 7 8 from php 8.2",
          "is_bot": false,
          "headline": "Laravel 10.x support (#115)",
          "author_name": "Ngô Quốc Đạt",
          "author_login": "datlechin",
          "committed_at": "2023-01-23T10:57:06Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3efd1f4850da899b02067d84b135022374f83215",
          "body": null,
          "is_bot": false,
          "headline": "Changed Github badge",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-12-16T14:38:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e69c88349f89639a8d83f66741a2b31cf6baba4d",
          "body": "* Allow macros calls on JoinClause\r\n\r\n* Fix variable name for macro\r\n\r\n* Fixing the formatting\r\n\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>\r\n\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>",
          "is_bot": false,
          "headline": "Allow Macro calls on JoinClause (#112)",
          "author_name": "glamax13",
          "author_login": "glamax13",
          "committed_at": "2022-12-09T10:31:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ad4ce611a67b60780507fb52eee7d62c810cd0ef",
          "body": "…g_polymorphic_relationships_in_readme\n\nFix class name in Joining polymorphic relationships section of Readme",
          "is_bot": false,
          "headline": "Merge pull request #108 from kirschbaum-development/fix/update_joinin…",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-08-24T14:22:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "eb56b2095ed5b0277eca85091d3df2343febf44f",
          "body": null,
          "is_bot": false,
          "headline": "Fix class name in Joining polymorphic relationships section of Readme",
          "author_name": "Fabian Alvarez",
          "author_login": "fabalv",
          "committed_at": "2022-08-24T00:44:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5285a670d5aa04db12317016247119da447e6196",
          "body": "Improve docs and tests on joins with a intermediate table",
          "is_bot": false,
          "headline": "Merge pull request #103 from marickvantuil/master",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-06-23T01:20:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1035dfca918963c7484c0c67a79ed1cb8fae55e9",
          "body": null,
          "is_bot": false,
          "headline": "Improve docs and tests on joins with a intermediate table",
          "author_name": "Marick van Tuil",
          "author_login": "marickvantuil",
          "committed_at": "2022-06-22T19:48:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "98e0ecc6844014a0169115ebea9985a89bbc61f2",
          "body": "Fixed using withTrashed and having an alias on a join clause",
          "is_bot": false,
          "headline": "Merge pull request #97 from jonneroelofs/jr_fix_wheres_become_collection",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-04-06T22:58:03Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3eef220c1c6b3c9b55b6c372d3f088c08a698c0d",
          "body": "…ame time.\n\nAdded a test.",
          "is_bot": false,
          "headline": "Fixed using withTrashed and having an alias on a join clause at the s…",
          "author_name": "jonneroelofs",
          "author_login": "jonneroelofs",
          "committed_at": "2022-04-06T07:47:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f66789d6468280a4cef136056ceae177476c3cb4",
          "body": null,
          "is_bot": false,
          "headline": "Addded Laravel 9 badge",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-03-06T01:37:17Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "71ffabe68e8c6de0b04f9b6904636d0d323a732e",
          "body": null,
          "is_bot": false,
          "headline": "Added additional test",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-03-06T01:03:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "704a3835ff4eb2cb8c66c8d69cbfd0a604a83a1f",
          "body": "Fixes for PHP 8.1 and Laravel 9",
          "is_bot": false,
          "headline": "Merge pull request #93 from kirschbaum-development/laravel-9-php-81",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-03-05T19:14:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "98c60cf9d56bb0802fa8d97288c365bd138a9bc4",
          "body": null,
          "is_bot": false,
          "headline": "Fixed for PHP 8.1 and Laravel 9",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-03-05T19:07:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "11a252145f953ec106c56160b3771b03f0afdccb",
          "body": "Potential Fix: Using `joinRelationship` on the same base relationship(s)",
          "is_bot": false,
          "headline": "Merge pull request #92 from kirschbaum-development/fix-issue-90",
          "author_name": "Luís Dalmolin",
          "author_login": "luisdalmolin",
          "committed_at": "2022-03-05T18:39:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 71,
      "commits_last_year": 9,
      "latest_release_at": "2026-05-28T20:36:23Z",
      "latest_release_tag": "4.3.2",
      "releases_from_tags": false,
      "days_since_last_push": 54,
      "active_weeks_last_year": 8,
      "days_since_latest_release": 54,
      "mean_days_between_releases": 35.8
    },
    "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": "kirschbaum-development/eloquent-power-joins",
          "exists": true,
          "license": "MIT",
          "keywords": [
            "mysql",
            "laravel",
            "join",
            "eloquent"
          ],
          "ecosystem": "packagist",
          "matches_repo": true,
          "registry_url": "https://packagist.org/packages/kirschbaum-development/eloquent-power-joins",
          "is_deprecated": false,
          "latest_version": "4.3.2",
          "repository_url": "https://github.com/kirschbaum-development/eloquent-power-joins",
          "versions_count": 78,
          "total_downloads": 34766417,
          "dependents_count": 35,
          "deprecation_note": null,
          "maintainers_count": null,
          "monthly_downloads": 2922088,
          "first_published_at": null,
          "latest_published_at": "2026-05-28T20:35:55Z",
          "latest_version_yanked": null,
          "days_since_latest_publish": 54
        }
      ]
    },
    "popularity": {
      "forks": 102,
      "stars": 1571,
      "watchers": 28,
      "fork_history": {
        "days": [
          {
            "date": "2020-04-18",
            "count": 1
          },
          {
            "date": "2020-04-19",
            "count": 1
          },
          {
            "date": "2020-04-20",
            "count": 1
          },
          {
            "date": "2020-05-27",
            "count": 1
          },
          {
            "date": "2020-09-03",
            "count": 1
          },
          {
            "date": "2020-09-18",
            "count": 1
          },
          {
            "date": "2020-11-15",
            "count": 1
          },
          {
            "date": "2020-11-27",
            "count": 1
          },
          {
            "date": "2021-01-06",
            "count": 1
          },
          {
            "date": "2021-01-18",
            "count": 1
          },
          {
            "date": "2021-02-17",
            "count": 1
          },
          {
            "date": "2021-02-20",
            "count": 1
          },
          {
            "date": "2021-03-11",
            "count": 1
          },
          {
            "date": "2021-03-26",
            "count": 2
          },
          {
            "date": "2021-03-31",
            "count": 2
          },
          {
            "date": "2021-04-07",
            "count": 1
          },
          {
            "date": "2021-04-10",
            "count": 1
          },
          {
            "date": "2021-04-16",
            "count": 2
          },
          {
            "date": "2021-05-09",
            "count": 1
          },
          {
            "date": "2021-05-19",
            "count": 1
          },
          {
            "date": "2021-06-30",
            "count": 1
          },
          {
            "date": "2021-07-01",
            "count": 1
          },
          {
            "date": "2021-08-05",
            "count": 1
          },
          {
            "date": "2021-08-20",
            "count": 1
          },
          {
            "date": "2021-09-09",
            "count": 1
          },
          {
            "date": "2021-09-17",
            "count": 1
          },
          {
            "date": "2021-10-03",
            "count": 1
          },
          {
            "date": "2021-10-14",
            "count": 2
          },
          {
            "date": "2021-10-28",
            "count": 1
          },
          {
            "date": "2021-11-01",
            "count": 1
          },
          {
            "date": "2021-11-02",
            "count": 1
          },
          {
            "date": "2021-12-09",
            "count": 1
          },
          {
            "date": "2021-12-21",
            "count": 2
          },
          {
            "date": "2021-12-28",
            "count": 1
          },
          {
            "date": "2022-01-28",
            "count": 1
          },
          {
            "date": "2022-02-03",
            "count": 1
          },
          {
            "date": "2022-02-06",
            "count": 1
          },
          {
            "date": "2022-02-08",
            "count": 1
          },
          {
            "date": "2022-02-09",
            "count": 1
          },
          {
            "date": "2022-03-16",
            "count": 1
          },
          {
            "date": "2022-04-06",
            "count": 2
          },
          {
            "date": "2022-04-11",
            "count": 1
          },
          {
            "date": "2022-05-30",
            "count": 1
          },
          {
            "date": "2022-07-11",
            "count": 1
          },
          {
            "date": "2022-08-01",
            "count": 1
          },
          {
            "date": "2022-08-06",
            "count": 1
          },
          {
            "date": "2022-08-26",
            "count": 1
          },
          {
            "date": "2022-09-03",
            "count": 1
          },
          {
            "date": "2022-10-04",
            "count": 1
          },
          {
            "date": "2022-10-31",
            "count": 1
          },
          {
            "date": "2022-12-20",
            "count": 1
          },
          {
            "date": "2023-02-20",
            "count": 1
          },
          {
            "date": "2023-03-13",
            "count": 1
          },
          {
            "date": "2023-04-03",
            "count": 1
          },
          {
            "date": "2023-04-08",
            "count": 1
          },
          {
            "date": "2023-04-23",
            "count": 1
          },
          {
            "date": "2023-04-24",
            "count": 1
          },
          {
            "date": "2023-06-14",
            "count": 1
          },
          {
            "date": "2023-06-20",
            "count": 1
          },
          {
            "date": "2023-09-01",
            "count": 1
          },
          {
            "date": "2023-09-12",
            "count": 1
          },
          {
            "date": "2023-09-27",
            "count": 1
          },
          {
            "date": "2023-10-06",
            "count": 1
          },
          {
            "date": "2023-10-12",
            "count": 1
          },
          {
            "date": "2023-10-28",
            "count": 1
          },
          {
            "date": "2024-02-02",
            "count": 1
          },
          {
            "date": "2024-02-13",
            "count": 1
          },
          {
            "date": "2024-02-16",
            "count": 1
          },
          {
            "date": "2024-03-05",
            "count": 1
          },
          {
            "date": "2024-03-19",
            "count": 1
          },
          {
            "date": "2024-03-20",
            "count": 2
          },
          {
            "date": "2024-04-19",
            "count": 1
          },
          {
            "date": "2024-04-23",
            "count": 1
          },
          {
            "date": "2024-07-10",
            "count": 1
          },
          {
            "date": "2024-07-26",
            "count": 1
          },
          {
            "date": "2024-09-09",
            "count": 1
          },
          {
            "date": "2024-11-09",
            "count": 1
          },
          {
            "date": "2024-11-26",
            "count": 1
          },
          {
            "date": "2025-01-27",
            "count": 1
          },
          {
            "date": "2025-02-05",
            "count": 2
          },
          {
            "date": "2025-03-02",
            "count": 1
          },
          {
            "date": "2025-03-04",
            "count": 1
          },
          {
            "date": "2025-04-03",
            "count": 1
          },
          {
            "date": "2025-05-03",
            "count": 1
          },
          {
            "date": "2025-07-23",
            "count": 1
          },
          {
            "date": "2025-08-08",
            "count": 1
          },
          {
            "date": "2025-08-14",
            "count": 1
          },
          {
            "date": "2025-10-03",
            "count": 1
          },
          {
            "date": "2026-01-25",
            "count": 1
          },
          {
            "date": "2026-02-13",
            "count": 1
          },
          {
            "date": "2026-02-22",
            "count": 1
          },
          {
            "date": "2026-04-15",
            "count": 1
          },
          {
            "date": "2026-05-28",
            "count": 1
          },
          {
            "date": "2026-07-21",
            "count": 1
          }
        ],
        "complete": true,
        "collected": 102,
        "total_forks": 102
      },
      "star_history": null,
      "open_issues_and_prs": 13
    },
    "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": 35930,
      "source_files_sampled": 58,
      "oversized_source_files": 0,
      "agent_instruction_files": [
        "AGENTS.md"
      ],
      "agent_instruction_max_bytes": 1115
    },
    "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": 7,
        "direct_affected_count": 0
      },
      "ecosystems": [
        "packagist"
      ],
      "dependencies": [
        {
          "name": "illuminate/support",
          "manifest": "composer.json",
          "ecosystem": "packagist",
          "version_constraint": "^11.42|^12.0|^13.0"
        },
        {
          "name": "illuminate/database",
          "manifest": "composer.json",
          "ecosystem": "packagist",
          "version_constraint": "^11.42|^12.0|^13.0"
        }
      ],
      "all_dependencies": {
        "error": null,
        "source": "github-sbom",
        "packages": [
          {
            "name": "illuminate/database",
            "direct": true,
            "version": null,
            "ecosystem": "packagist"
          },
          {
            "name": "illuminate/support",
            "direct": true,
            "version": null,
            "ecosystem": "packagist"
          },
          {
            "name": "friendsofphp/php-cs-fixer",
            "direct": false,
            "version": null,
            "ecosystem": "packagist"
          },
          {
            "name": "laravel/legacy-factories",
            "direct": false,
            "version": null,
            "ecosystem": "packagist"
          },
          {
            "name": "orchestra/testbench",
            "direct": false,
            "version": null,
            "ecosystem": "packagist"
          },
          {
            "name": "php",
            "direct": false,
            "version": null,
            "ecosystem": "packagist"
          },
          {
            "name": "phpunit/phpunit",
            "direct": false,
            "version": null,
            "ecosystem": "packagist"
          }
        ],
        "collected": true,
        "truncated": false,
        "total_count": 7,
        "direct_count": 2,
        "indirect_count": 5
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 3,
        "merged_prs": 83,
        "open_issues": 10,
        "closed_ratio": 0.922,
        "closed_issues": 118,
        "closed_unmerged_prs": 21
      },
      "bus_factor": 1,
      "bot_contributors": 0,
      "top_contributors": [
        {
          "type": "User",
          "login": "luisdalmolin",
          "commits": 212,
          "avatar_url": "https://avatars.githubusercontent.com/u/403446?v=4"
        },
        {
          "type": "User",
          "login": "GeoSot",
          "commits": 5,
          "avatar_url": "https://avatars.githubusercontent.com/u/22406063?v=4"
        },
        {
          "type": "User",
          "login": "niektenhoopen",
          "commits": 5,
          "avatar_url": "https://avatars.githubusercontent.com/u/3450011?v=4"
        },
        {
          "type": "User",
          "login": "brandonferens",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/1819546?v=4"
        },
        {
          "type": "User",
          "login": "danharrin",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/41773797?v=4"
        },
        {
          "type": "User",
          "login": "marickvantuil",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/647007?v=4"
        },
        {
          "type": "User",
          "login": "jonneroelofs",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/20800818?v=4"
        },
        {
          "type": "User",
          "login": "lopesrbruno",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/88719327?v=4"
        },
        {
          "type": "User",
          "login": "Runig006",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/26311663?v=4"
        },
        {
          "type": "User",
          "login": "luilliarcec",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/27895611?v=4"
        }
      ],
      "contributors_sampled": 35,
      "top_contributor_share": 0.788
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "ci.yaml",
        "lint.yml"
      ],
      "has_docs_dir": false,
      "linter_configs": [
        ".php-cs-fixer.php"
      ],
      "has_editorconfig": true,
      "has_linter_config": true,
      "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": 0,
            "reason": "branch protection not enabled on development/release branches",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
          },
          {
            "name": "CI-Tests",
            "score": 4,
            "reason": "10 out of 21 merged PRs checked by a CI test -- score normalized to 4",
            "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": 3,
            "reason": "Found 11/30 approved changesets -- score normalized to 3",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 10,
            "reason": "project has 4 contributing companies or organizations",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": null,
            "reason": "no workflows found",
            "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": 1,
            "reason": "1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1",
            "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": null,
            "reason": "no dependencies found",
            "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": null,
            "reason": "No tokens found",
            "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": "33c189bd51a510c1ceba67222395ead08a29863a",
        "ran_at": "2026-07-22T18:04:31Z",
        "aggregate_score": 3.4,
        "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-05-28T20:38:16Z",
      "oldest_open_prs": [
        {
          "number": 142,
          "created_at": "2023-07-06T23:47:18Z",
          "last_comment_at": "2023-10-22T19:25:15Z",
          "last_comment_author": "GeoSot"
        },
        {
          "number": 220,
          "created_at": "2025-08-06T12:47:40Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 234,
          "created_at": "2026-04-15T05:38:34Z",
          "last_comment_at": "2026-04-27T18:17:55Z",
          "last_comment_author": "vasconcelos-giovanni"
        }
      ],
      "last_merged_pr_at": "2026-05-28T20:35:56Z",
      "ci_last_conclusion": "SUCCESS",
      "oldest_open_issues": [
        {
          "number": 34,
          "created_at": "2020-10-26T17:25:09Z",
          "last_comment_at": "2023-11-14T15:29:25Z",
          "last_comment_author": "luisdalmolin"
        },
        {
          "number": 49,
          "created_at": "2021-04-04T21:56:42Z",
          "last_comment_at": "2023-06-19T19:56:43Z",
          "last_comment_author": "luisdalmolin"
        },
        {
          "number": 156,
          "created_at": "2023-09-26T09:52:45Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 181,
          "created_at": "2024-06-12T17:05:51Z",
          "last_comment_at": "2024-06-12T17:21:16Z",
          "last_comment_author": "luisdalmolin"
        },
        {
          "number": 190,
          "created_at": "2024-11-02T20:46:35Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 193,
          "created_at": "2024-12-11T12:23:35Z",
          "last_comment_at": "2025-09-01T06:19:14Z",
          "last_comment_author": "Estigy"
        },
        {
          "number": 197,
          "created_at": "2025-01-27T07:21:28Z",
          "last_comment_at": "2025-01-27T09:04:53Z",
          "last_comment_author": "luisdalmolin"
        },
        {
          "number": 218,
          "created_at": "2025-08-06T10:51:11Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 219,
          "created_at": "2025-08-06T10:51:54Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 235,
          "created_at": "2026-05-13T09:48:19Z",
          "last_comment_at": "2026-05-13T10:09:44Z",
          "last_comment_author": "mschop"
        }
      ]
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/kirschbaum-development/eloquent-power-joins",
    "host": "github.com",
    "name": "eloquent-power-joins",
    "owner": "kirschbaum-development"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "moderate",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 63,
      "inputs": {
        "security": 34,
        "vitality": 60,
        "community": 77,
        "governance": 68,
        "engineering": 71
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "moderate",
        "name": "Vitality",
        "value": 60,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "at_risk",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 34,
            "inputs": {
              "commits_last_year": 9,
              "human_commit_share": 1,
              "days_since_last_push": 54,
              "active_weeks_last_year": 8
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 54 days ago",
                "points": 18,
                "status": "partial",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 54
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "8/52 weeks with commits",
                "points": 5.5,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 8
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "9 commits in the last year",
                "points": 9,
                "status": "partial",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 9
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1",
                "points": 1,
                "status": "partial",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "excellent",
            "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": 100,
            "inputs": {
              "releases_count": 71,
              "latest_release_tag": "4.3.2",
              "releases_from_tags": false,
              "days_since_latest_release": 54,
              "mean_days_between_releases": 35.8
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "71 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 71
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 54 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 54
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~35.8 days",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 35.8
                    }
                  }
                ],
                "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": "maintained",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": null,
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": 54,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "last human commit 54 days ago",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_maintained",
                    "params": {
                      "days": 54
                    }
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "good",
        "name": "Community & Adoption",
        "value": 77,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "good",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 76,
            "inputs": {
              "forks": 102,
              "stars": 1571,
              "watchers": 28,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "1,571 stars",
                "points": 51.8,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 1571
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "102 forks",
                "points": 16.7,
                "status": "partial",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 102
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "28 watchers",
                "points": 8,
                "status": "partial",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 28
                    }
                  }
                ],
                "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": "excellent",
            "name": "Ecosystem adoption (downloads)",
            "note": null,
            "notes": [],
            "value": 90,
            "inputs": {
              "packages": [
                "kirschbaum-development/eloquent-power-joins"
              ],
              "dependents": 35,
              "ecosystems": "packagist",
              "total_downloads": 34766417,
              "monthly_downloads": 2922088
            },
            "components": [
              {
                "key": "monthly_downloads",
                "name": "Monthly downloads",
                "detail": "2,922,088 downloads/month across packagist",
                "points": 80,
                "status": "met",
                "details": [
                  {
                    "code": "downloads_monthly",
                    "params": {
                      "count": 2922088,
                      "ecosystems": "packagist"
                    }
                  }
                ],
                "max_points": 80
              },
              {
                "key": "registry_dependents",
                "name": "Registry dependents",
                "detail": "35 packages depend on it",
                "points": 10.4,
                "status": "partial",
                "details": [
                  {
                    "code": "registry_dependents",
                    "params": {
                      "count": 35
                    }
                  }
                ],
                "max_points": 20
              }
            ]
          }
        ],
        "description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
      },
      {
        "key": "governance",
        "band": "moderate",
        "name": "Sustainability & Governance",
        "value": 68,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "at_risk",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 37,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 35,
              "top_contributor_share": 0.788
            },
            "components": [
              {
                "key": "bus_factor",
                "name": "Bus factor",
                "detail": "1 contributor(s) cover half of all commits",
                "points": 9,
                "status": "partial",
                "details": [
                  {
                    "code": "bus_factor",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "max_points": 54
              },
              {
                "key": "commit_distribution",
                "name": "Commit distribution",
                "detail": "top contributor authored 79% of commits",
                "points": 4.8,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 79
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "35 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 35
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 4 contributing companies or organizations",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "good",
            "name": "Issue & PR responsiveness",
            "note": null,
            "notes": [],
            "value": 78,
            "inputs": {
              "merged_prs": 83,
              "open_issues": 10,
              "closed_issues": 118,
              "issue_closed_ratio": 0.922,
              "closed_unmerged_prs": 21
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "92% of issues closed",
                "points": 43.1,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 92
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "83/104 decided PRs merged",
                "points": 30.5,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 83,
                      "decided": 104
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 11/30 approved changesets -- score normalized to 3",
                "points": 4.5,
                "status": "partial",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "good",
            "name": "Ownership & stewardship",
            "note": null,
            "notes": [],
            "value": 70,
            "inputs": {
              "followers": 159,
              "owner_type": "Organization",
              "is_verified": null,
              "owner_login": "kirschbaum-development",
              "public_repos": 49,
              "account_age_days": 3106
            },
            "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": "159 followers of kirschbaum-development",
                "points": 15.8,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 159,
                      "login": "kirschbaum-development"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "49 public repos, account ~8 yr old",
                "points": 24.4,
                "status": "partial",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 49
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 8
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          },
          {
            "key": "package_maintenance",
            "band": "excellent",
            "name": "Package maintenance",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "packages": [
                "kirschbaum-development/eloquent-power-joins"
              ],
              "ecosystems": "packagist",
              "any_deprecated": false,
              "min_days_since_publish": 54
            },
            "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 54 days ago",
                "points": 35,
                "status": "met",
                "details": [
                  {
                    "code": "publish_recency",
                    "params": {
                      "days": 54
                    }
                  }
                ],
                "max_points": 35
              },
              {
                "key": "version_history",
                "name": "Version history",
                "detail": "78 published versions",
                "points": 20,
                "status": "met",
                "details": [
                  {
                    "code": "published_versions",
                    "params": {
                      "count": 78
                    }
                  }
                ],
                "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": "good",
        "name": "Engineering Quality",
        "value": 71,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "good",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 78,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": true,
              "has_linter_config": true,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "2 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 2
                    }
                  }
                ],
                "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": ".php-cs-fixer.php",
                "points": 16,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".php-cs-fixer.php"
                    }
                  }
                ],
                "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": 6.4,
                "status": "met",
                "details": [],
                "max_points": 6.4
              },
              {
                "key": "openssf_scorecard_ci_tests",
                "name": "OpenSSF Scorecard: CI-Tests",
                "detail": "10 out of 21 merged PRs checked by a CI test -- score normalized to 4",
                "points": 8,
                "status": "partial",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "moderate",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 60,
            "inputs": {
              "topics": [
                "hacktoberfest",
                "laravel",
                "php"
              ],
              "has_wiki": true,
              "homepage": null,
              "has_readme": true,
              "has_docs_dir": false,
              "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": 0,
                "status": "missed",
                "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": "3 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 3
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "at_risk",
        "name": "Security",
        "value": 34,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "at_risk",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Dangerous-Workflow, Packaging, Pinned-Dependencies, Signed-Releases, Token-Permissions. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "dangerous_workflow",
                    "packaging",
                    "pinned_dependencies",
                    "signed_releases",
                    "token_permissions"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 34,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 13,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 5,
              "scorecard_aggregate": 3.4
            },
            "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": "branch protection not enabled on development/release branches",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "10 out of 21 merged PRs checked by a CI test -- score normalized to 4",
                "points": 1,
                "status": "partial",
                "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/30 approved changesets -- score normalized to 3",
                "points": 2.2,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 4 contributing companies or organizations",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no workflows found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "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": "1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1",
                "points": 0.8,
                "status": "partial",
                "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": "no dependencies found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "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": "No tokens found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "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": 13
            },
            "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": "moderate",
        "name": "AI Readiness",
        "value": 53,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "good",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 74,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.54,
              "agent_instruction_files": [
                "AGENTS.md"
              ],
              "agent_instruction_max_bytes": 1115
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "AGENTS.md",
                "points": 45,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "AGENTS.md"
                    }
                  }
                ],
                "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": "54 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 28.8,
                "status": "partial",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 54,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "at_risk",
            "name": "Verify loop (build / test / typecheck)",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Pinned-Dependencies. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_pinned_dependencies"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 37,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [],
              "has_dockerfile": false,
              "typed_language": false,
              "bootstrap_files": [],
              "has_devcontainer": false,
              "has_linter_config": true,
              "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": ".php-cs-fixer.php",
                "points": 11,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": ".php-cs-fixer.php"
                    }
                  }
                ],
                "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": "no dependencies found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "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": 35930,
              "source_files_sampled": 58,
              "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/58 source files over 60KB",
                "points": 55,
                "status": "met",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 58,
                      "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-22T18:04:56.916285Z",
  "schema_version": "0.26.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/k/kirschbaum-development/eloquent-power-joins.svg",
  "full_name": "kirschbaum-development/eloquent-power-joins",
  "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.26.0 — full methodology · metrics wiki.

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