SQLite3Result::fetchArray Doesn't Handle Join Statement Properly

When i tried using ( join ) statement for fetching data , sqlite3 tend to overwrite the column name if it appears in the other table

• eg:

table-a

table-b

When i try to join them

SELECT * FROM table-a a JOIN table-b b ON(a.foreign_id=b.id)

i get the result as follows

[
  array(
  'ID' => 2,
  'name' => 'foo',
  'foreign_id' => 2
  )
]

i suggest prefixing the columns names with the table aliases name to clarify and avoid overwriting

So the result would be like this

[
 array(
  'a.ID' => 1,
  'a.name' => 'bar',
  'a.Foreign_id' => 2,
  'b.ID' => 2,
  'b.name' => 'foo'
 )
]

thanks in advance

From manual page: https://php.net/sqlite3result.fetcharray

Comienza por la página del manual enlazada de SQLite3Result::fetchArray y reproduce la consulta SELECT * JOIN reportada usando las dos tablas de ejemplo. Determina el tratamiento previsto de los nombres de columna duplicados y confirma la forma de resultado aceptada antes de cambiar o probar el comportamiento.