table.lastInsertID is misrepresented, should be moved to connection

[guzman-raphael]

Feature Request

Problem

Currently, tables have a property lastInsertID which returns the last generated auto-incremented value. However, it is misrepresented as associated with the table when the logic actually relates to the connection.

Requirements

We should:

• add a property to connection with the same name
• deprecate this property on tables
• point users to new reference

Justification

The query used is SELECT last_insert_id() which based on MySQL docs directly relates to the client connection (see reference below).

Additional Research and Context

• https://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_last-insert-id