update spec for OVER/IN syntax in from clause
also added support for explict pool-name in FROM clause