auraphp / Aura.SqlQuery

Wann jeder Stern und Fork hinzugefügt wurde, von GitHub erfasst und nach Tagen gruppiert. Das kumulierte Wachstum steht direkt über den täglichen Zugängen, aus denen es besteht, sodass beide gegeneinander lesbar sind: stetiger organischer Zuwachs sieht ganz anders aus als ein abrupter, kurzlebiger Ausschlag. Wo dieser Unterschied messbar ist, wird er als Wachstumsauthentizität ausgewiesen.

Jeder Punkt umfasst 11 Tage.

Vollständig aufgelöster Abhängigkeitssatz aus dem GitHub-Abhängigkeitsgraphen: 0 direkte und 3 indirekte (transitive) Pakete. Die transitive Hülle ist vollständig, wenn das Repository eine Lockfile eincheckt.

Der Advisory-Abgleich konnte für diesen Bericht nicht ausgeführt werden: No resolved dependencies carried a version and a supported ecosystem

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