pydal-20241204.1 with_alias + as_list broke backward compatibilty with old code.

[mbelletti]

The latest versions of pydal introduced a breaking change in the behavior of the with_alias method used with as_list. In the previous version (20241111.2), when using with_alias with as_list, the aliased fields were returned as keys of the dict representing the record, but in the latest version, they are only available in the _extra dict.

It seems the bug is introduced here: 16c9395

This change breaks backward compatibility with existing code that relied on the old behavior.

from pydal import DAL, Field
db = DAL('sqlite:memory')
db.define_table('test',
                Field('a'),
               )
for i in range(3):
    db.test.insert(a=str(i))
db.commit()  
print(db(db.test.id).select(db.test.a.with_alias('my_col_name')).as_list())

pydal-20241111.2

[{'my_col_name': '0', '_extra': {'"test"."a" AS my_col_name': '0'}},
 {'my_col_name': '1', '_extra': {'"test"."a" AS my_col_name': '1'}},
 {'my_col_name': '2', '_extra': {'"test"."a" AS my_col_name': '2'}},

pydal-20241204.1

[{'_extra': {'my_col_name': '0'}},
 {'_extra': {'my_col_name': '1'}},
 {'_extra': {'my_col_name': '2'}},