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

Commencez par la page de manuel liée de SQLite3Result::fetchArray et reproduisez la requête SELECT * JOIN signalée à l’aide des deux tables d’exemple. Déterminez le traitement prévu des noms de colonnes en double et confirmez la forme de résultat acceptée avant de modifier ou de tester le comportement.