Hi Decker, The last one is the one expected. If queried with `nestTables` positive, the result should be something like:
[ { foo: { id: 1, parent_id: 3 }, bar: { id: 3, parent_id: null } }, { foo: { id: 2, parent_id: 4 }, bar: { id: 4, parent_id: null } } ] Regarding your patch, is that patch official? I've noticed the comment saying sqlite3_column_table_alias_name would be available after 3.22.0. It would be helpful since I've been trying to apply the patch to amalgamation but failed to get table alias yet :-( Sorry for not able to reply to your email directly. I opted to receive subscriptions in daily digest. It seems there's no way to revert this option. Jake _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users