Registro público
Informe de salud del softwareesquema 0.27.0 · métricas 1.13.0 · 2026-07-24 21:33 UTC

auraphp / Aura.SqlQuery

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

PHPMIT★ 456 estrellas⑂ 87 forksdesde sept 2013Ver en GitHub ↗

auraphp/Aura.SqlQuery tiene un índice de salud de 58 sobre 100, lo que lo sitúa en la banda Moderado. Su puntuación más alta es Sustainability & Governance (74/100) y la más baja, AI Readiness (27/100). Se actualizó por última vez hoy. 3 personas concentran la mayor parte del trabajo reciente.

58
global / 100
Moderado

Índice de salud del software

Las métricas se agrupan en categorías ponderadas sobre una escala de 1 a 100. El resultado global parte de su media; cuando la evidencia pública activa la Política de Jurisdicciones de Alto Riesgo, la calificación se ajusta y recibe el límite 49 (En riesgo). Preparación para IA queda fuera.

58
Excelente85-100Ejemplar; cumple prácticamente todos los criterios evaluados
Bueno70-84Saludable; carencias menores
Moderado50-69Aceptable con carencias notables; se recomienda revisión
En riesgo30-49Debilidades significativas; su adopción exige cautela
Crítico1-29Problemas graves (proyecto abandonado, un solo mantenedor, sin higiene)
VitalidadComunidad yAdopciónSostenibilidady GobernanzaCalidad deIngenieríaSeguridadPreparaciónpara IA

Perfil de puntuación

Cada eje es una categoría. La forma importa más que la media: un proyecto sano llena toda la figura, mientras que un perfil de picos y cráteres indica que la fortaleza en una dimensión enmascara el riesgo en otra.

Titularidad

Aura for PHPOrganización
63 seguidores41 repositorios públicosdesde feb 2011

Este repositorio está respaldado por una organización: una custodia compartida y responsable que puede sobrevivir a cualquier mantenedor individual.

Ecosistemas de paquetes

RegistroPaqueteVersiónDescargas / mesVersionesÚltima publicaciónEtiquetas
Packagistaura/sqlquery3.0.058.48216hace 1186 díasdatabasesqldbmysqlsqlitepostgresqlquerypdopgsqlpostgressql-serversqlserverupdateinsertselectdeletedml

Métricas por categoría

Vitalidad

¿Está vivo el proyecto: se escribe código y se publican versiones?

43En riesgo · 22% del índice global
Cómo se puntúa
36/36Recencia de push — último push hace 0 días
1.4/36Cadencia de commits — 2/52 semanas con commits
4.3/18Volumen de commits — 2 commits en el último año
0/10OpenSSF Scorecard: Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
Datos de entrada utilizados
commits_last_year2
human_commit_share1
days_since_last_push0
active_weeks_last_year2
Cómo se puntúa
27/27Publica versiones — 16 versiones publicadas
0/36Recencia de las versiones — última versión hace 1186 días
12.6/27Cadencia de publicación — una versión cada ~328 días
0/10OpenSSF Scorecard: Signed-Releases — sin datos
Datos de entrada utilizados
releases_count16
latest_release_tag2.8.1
releases_from_tagsno
days_since_latest_release1186
mean_days_between_releases328
Excluidos de la puntuación (sin datos o no aplicable): OpenSSF Scorecard: Signed-Releases. Los pesos restantes se han renormalizado.

Comunidad y Adopción

¿Tiene el proyecto usuarios, descargas, atención y unas condiciones acogedoras para quienes contribuyen?

70Bueno · 18% del índice global
Cómo se puntúa
43.1/60Estrellas — 456 estrellas
16.1/25Forks — 87 forks
8.3/15Observadores — 32 observadores
Datos de entrada utilizados
forks87
stars456
watchers32
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history
Cómo se puntúa
22.5/22.5README
22.5/22.5Licencia — licencia reconocida (MIT)
18/18Guía CONTRIBUTING
0/13.5Código de conducta
0/7.2Plantilla de issues
0/6.3Plantilla de PR
Datos de entrada utilizados
has_readme
has_license
has_contributing
has_issue_templateno
has_code_of_conductno
has_pull_request_templateno
Cómo se puntúa
63.6/80Descargas mensuales — 58.482 descargas/mes en packagist
11/20Dependientes en el registro — 43 paquetes dependen de él
Datos de entrada utilizados
packagesaura/sqlquery
dependents43
ecosystemspackagist
total_downloads3.166.534
monthly_downloads58.482

Sostenibilidad y Gobernanza

¿Sobrevivirá el proyecto a sus personas: factor bus, capacidad de respuesta, quién lo respalda y mantenimiento del paquete?

74Bueno · 24% del índice global
Cómo se puntúa
36/54Factor bus — la mitad de los commits recae en 3 contribuyente(s)
16.7/22.5Distribución de commits — el principal contribuyente firma el 26% de los commits
13.5/13.5Amplitud de contribuyentes — 36 contribuyentes
10/10OpenSSF Scorecard: Contributors — project has 12 contributing companies or organizations
Datos de entrada utilizados
bus_factor3
contributors_sampled36
top_contributor_share0,259
Cómo se puntúa
36.3/46.8Resolución de issues — 78% de issues cerradas
32.4/38.3Aceptación de PR — 94/111 PR decididos fusionados
13.5/15OpenSSF Scorecard: Code-Review — Found 11/12 approved changesets -- score normalized to 9
Datos de entrada utilizados
merged_prs94
open_issues22
closed_issues76
issue_closed_ratio0,776
closed_unmerged_prs17
Cómo se puntúa
30/30Respaldo de la propiedad — propiedad de una organización
0/20Dominio verificado
13/25Alcance del propietario — 63 seguidores de auraphp
23.8/25Trayectoria — 41 repos públicos, cuenta de ~15 años
Datos de entrada utilizados
followers63
owner_typeOrganization
is_verified
owner_loginauraphp
public_repos41
account_age_days5642
Cómo se puntúa
25/25Publicado y resoluble — 1 paquete(s) en packagist
4/35Recencia de publicación — última publicación hace 1186 días
20/20Historial de versiones — 16 versiones en el registro
20/20No obsoleto — activo, ni obsoleto ni retirado
Datos de entrada utilizados
packagesaura/sqlquery
ecosystemspackagist
any_deprecatedno
min_days_since_publish1186

Calidad de Ingeniería

¿Existen unas prácticas mínimas de ingeniería y documentación?

59Moderado · 20% del índice global
Cómo se puntúa
24/24Flujos de trabajo de CI — 1 flujo(s) de trabajo
24/24Pruebas presentes
0/16Configuración de linter
0/9.6Hooks de pre-commit
0/6.4.editorconfig
0/20OpenSSF Scorecard: CI-Tests — 1 out of 11 merged PRs checked by a CI test -- score normalized to 0
Datos de entrada utilizados
has_ci
has_tests
has_editorconfigno
has_linter_configno
has_precommit_configno
Cómo se puntúa
30/30README
25/25Directorio de documentación
0/15Sitio de documentación / página del proyecto
10/10Descripción del repositorio
10/10Topics — 6 topics
0/10Wiki
Datos de entrada utilizados
topicsquery-builder, php, mysql, postgresql, microsoft-sql-server, sqlite
has_wikino
homepage
has_readme
has_docs_dir
has_description

Seguridad

¿Son sólidas las prácticas visibles de seguridad y de cadena de suministro, sin exposición jurisdiccional de alto riesgo sin resolver?

43En riesgo · 16% del índice global
Cómo se puntúa
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — sin datos
0/2.5CI-Tests — 1 out of 11 merged PRs checked by a CI test -- score normalized to 0
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
6.8/7.5Code-Review — Found 11/12 approved changesets -- score normalized to 9
2.5/2.5Contributors — project has 12 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5Licencia — license file detected
0/7.5Maintained — 0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
0/5Packaging — sin datos
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
0/5SAST — SAST tool is not run on all commits -- score normalized to 0
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — sin datos
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
7.5/7.5Vulnerabilities — 0 existing vulnerabilities detected
Datos de entrada utilizados
sourceopenssf_scorecard
checks_evaluated15
scorecard_versionv5.5.0
checks_inconclusive3
scorecard_aggregate4,3
Excluidos de la puntuación (sin datos o no aplicable): branch_protection, packaging, signed_releases. Los pesos restantes se han renormalizado.

Preparación para IA

¿Hasta qué punto está el repositorio preparado para desarrollarse y mantenerse con agentes de codificación de IA? Es una insignia independiente y experimental — peso 0,0, de modo que se presenta por separado y no afecta a la puntuación de salud global.

27Crítico · 0% del índice global
Cómo se puntúa
0/45Instrucciones para agentes — sin CLAUDE.md / AGENTS.md / reglas de editor
0/15Documentación legible por máquinas (llms.txt)
18.7/40Historial de commits legible — 35 de 100 commits humanos declaran su intención (asunto estructurado o cuerpo explicativo)
Datos de entrada utilizados
has_llms_txtno
legible_history_share0,35
agent_instruction_files
agent_instruction_max_bytes
Cómo se puntúa
0/18Arranque con un solo comando
22/22Pruebas automatizadas
0/11Configuración de lint / formato
0/11Verificación estática de tipos
0/10Entorno reproducible
0/10Práctica demostrada con agentes — ningún commit con autoría de agente entre los últimos 100
0/8Mantenimiento automatizado — no se observan actualizaciones automáticas de dependencias
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Datos de entrada utilizados
has_nixno
has_tests
lockfiles
has_dockerfileno
typed_languageno
bootstrap_files
has_devcontainerno
has_linter_configno
typecheck_configs
agent_commit_share0
toolchain_manifests
dependency_bot_commit_share0
Cómo se puntúa
0/45Código verificable por tipos — PHP sin configuración de verificación de tipos
55/55Tamaños de archivo manejables — 0/79 archivos fuente de más de 60 KB
Datos de entrada utilizados
primary_languagePHP
largest_source_bytes30.633
source_files_sampled79
oversized_source_files0

Datos clave

456estrellas de GitHub
36contribuidores
2commits en los últimos 12 meses
0días desde el último push
16versiones publicadas
3factor bus
22issues abiertas
Packagistecosistemas de paquetes

Advertencias de recopilación de datos

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

Más detalle

Historial de estrellas y forks 0 ★ / 87 ⇿
0Estrellas
87Forks
16Versiones

Cuándo se añadió cada estrella y fork, recopilado de GitHub y agrupado por día. El crecimiento acumulado se sitúa justo encima de las adiciones diarias que lo componen, de modo que ambos se leen en conjunto: la acumulación orgánica sostenida no se parece en nada a un pico abrupto y efímero. Cuando esa diferencia es medible, se informa como autenticidad del crecimiento.

0204060801008362013-102019-052024-12
Mayor 2Menor 8Parche 4

Cada punto abarca 11 días.

OpenSSF Scorecard 4.3 / 10
4.3agregado

Evaluación de seguridad independiente y agnóstica en cuanto a herramientas, procedente del proyecto de código abierto OpenSSF Scorecard. Cada comprobación premia una práctica de seguridad, no la herramienta de un proveedor concreto. Las comprobaciones que Scorecard no pudo determinar se marcan como n/d y se excluyen de la puntuación de seguridad (nunca se cuentan como cero).Scorecard v5.5.0 · 2026-07-24 21:33 UTC

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

Conjunto completo de dependencias resueltas según el grafo de dependencias de GitHub: 0 paquetes directos y 3 indirectos (transitivos). El cierre transitivo es completo cuando el repositorio incluye un lockfile.

RegistroPaqueteVersiónRelación
Packagistext-pdo_sqliteindirecta
Packagistphpindirecta
Packagistyoast/phpunit-polyfillsindirecta
Avisos de dependencias sin evaluar

El cotejo de avisos no pudo ejecutarse para este informe: No resolved dependencies carried a version and a supported ecosystem

Informe JSON sin procesar legible por máquina
{
  "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"
}

Las puntuaciones son señales, no garantías. Reflejan prácticas públicamente visibles en GitHub; no son una auditoría de código ni una garantía de seguridad.

Los datos ausentes se excluyen y los pesos se renormalizan; nunca se puntúan como cero. La metodología es versionada y abierta: métricas v1.13.0, esquema v0.27.0 — metodología completa · wiki de métricas.

Cómo se sitúa un resultado dentro del registro general: estadísticas agregadasPackagist.