Sasha Alex Romanenko

@ezimuel Moving some of current questions I have from original bug report here so its easier for you to follow. Thank you for the blog post! Was motivational. Not pressuring...

According to https://github.com/zendframework/zendframework/issues/3224 should be ``` use Zend\Db\Sql\Select; public function method() { $select = new Select(); $select->from(['a' => $this->table]) ->join(['b'=>USERS_TABLE],'b.id = a.owner_id ', ['author' => new Expression("CONCAT(`b`.`first_name`,' ',`b`.`family_name`)")],Select::JOIN_LEFT) ->where(['a.owner_id' =>...

That looks so bad. An SQL statement builder that depends on adapter, even though the whole point is not worry about vendor specific, and then have to recreate whole object...

Yes, I meant as an API improvement. But preferably without aware trait, since SM 3 worked on not using those anymore. Or maybe this is an acceptable exception.

But then @turrsis already has PR which separates this annoyance into SQL as abstract declarative object, and builder which parses it based on adapter (hope thats a decent description). Maybe...

Mine took 5.8 seconds on 239 tables :D (used jira database as test) Indeed, this is a problem if used to find details for a single table. But for that,...

That is a clever solution to one off usage like this (with no tablegateway) . Thank you for sharing!

This problem is starting to affect me too in my migrations project having these queries run on every page request. With some research turns out `information_schema` implementation for sake of...

P.S. Maybe also consider lazy loading some of table properties, like constraints and columns. I feel full metadata detail queried at once will still cause huge execution plans, even if...

OO OO this one is even faster! ``` SELECT c.relname as table_name, c.relkind as table_type FROM pg_class c WHERE c.relnamespace = (SELECT oid FROM pg_namespace WHERE nspname = 'public') AND...