Solidifying Lucid with bunch of new features and bug fixes

Highlights

• Support for query scopes with proper intellisense
• Option to define hooks by decorating functions
• A standard way to listen for database query events using the Event module of AdonisJS.
• Helper function to pretty print SQL query logs
• Support for Pagination
• Support for Global transactions. Helpful during tests
• Added tests to run on MSSQL too.

Commits

• feat: allow defining hooks via decorators ae2f398
• style: fix after rebase c9b0e24
• improvement: use toSQL method directly, since knex has added it to their types b3f9917
• chore: cleanup dependencies f697a38
• style: improve log message in migrations command 2a0db32
• improvement: raise error when trying to merge or fill extra properties to model 003f1c4
• improvement: raise error when trying to merge or fill extra properties to model 1167b54
• refactor: use mustache syntax for stubs ebee5fb
• chore: update dependencies b20776a
• feat: accept custom data to set set on query event e9f944b
• refactor: pass model name to query reporter for updates, deletes and inserts 87f9599
• fix: return ModelQuery builder for update and deletes 4a6f165
• refactor: re-organize code f09f4f6
• fix: use fromSQL method to convert sql date times to luxon instances 40d528d
• chore: update database config template to drop Contract from config types f058141
• refactor: depreciate "debug" config property b536acc
• refactor: cleaning up migration commands b6dc1ce
• refactor: nest transaction queries inside profiler row 06f361a
• feat: add querylogs pretty printer 4281d1f
• feat: emit db queries 1466b31
• test: fix breaking test 297acd1
• fix: provider to export orm config 6bddf84
• feat: expose SimplePaginator on database object for manual construction f533fe5
• feat(paginator): add getUrlsForRange method 8cac552
• feat: add first and firstOrFail as static model methods 05f2422
• refactor: drop Contract keyword from everything except implmentable interfaces b5302d5
• refactor: extract Model.defineScope to its own helper method 5c150b8
• feat: implement fetch and find hooks 5e125f9
• refactor: serialize dates to ISODate string by default be8a9f8
• chore: update .env file d07d5ca
• feat: implement relationships onQuery hook 9b58684
• feat: implement query scopes 88cf86b
• refactor: huge cleanup to simplify things all around f268dea
• WIP 6c44456
• refactor: cleanup query builder types 0096e76
• test: add tests for clone method 6286276
• feat: implement standard offset,limit based pagination d3584fe
• feat(QueryBuilder): add clearLimit and clearOffset methods 6ba940f
• test: add tests for union queries 6293d2f
• refactor: add connection name to the query log messages a3a494b
• feat: add schema.raw to get an instance of knex query builder 5570d10
• test: use client.context over client._context after recent change in knex 2686a5c
• fix: having method signature after knex upgrade 9ba7f89
• chore: update dependencies f13f503
• refactor: update code to work consistently with mssql 6874d59
• fix: add missing dev dependency mssql d338c93
• test: update tests to work cross database servers 8fa6cce
• refactor: fixing import case 8cd21d6
• chore: add support for running tests on mssql server 5c35853
• feat: add getAllTables method to get a list of all table names as an array e48709f
• feat: extend validator by adding unique and exists rules 4768c3c
• feat: add support for self managed transactions 0e2f6ee
• chore: update dependencies 3398653

v7.6.3...v8.0.0