fix: dropIndex now works when providing a tableIndex without name

[Thellior]

Description of change

Fixes #8936

• Added a protected generateIndexName on BaseQueryRunners that generates a index name
  • This code was the same on all createIndex function implementation thus made it a generic method
• Added a if statement on all dropIndex methods of QueryRunners to generate a indexName if there is none on the TableIndex
• Added github-issue unit test to verify that this solves the issue

Pull-Request Checklist

• [ x] Code is up-to-date with the master branch
• [ x] npm run format to apply prettier formatting
• [ x] npm run test passes with this change
• [ x] This pull request links relevant issues as Fixes #0000
• [ x] There are new or updated unit tests validating the change
• [ x] Documentation has been updated to reflect this change
• [ x] The new commits follow conventions explained in CONTRIBUTING.md

[Thellior]

I couldn't figure out what the best way was to get the tableName of the entity. If there is a better way I would like to know how so i can change it 😄

[Thellior]

Also I cannot get the Oracle DB to work locally either on an intel and M1 machine. Is there some extra guidance available?. I checked the Developer documentation already and followed that steps

[Thellior]

@pleerock Is there any update on this or something I can do about it in the mean time :)

[AlexMesser]

thank you for contribution!