fix bugs in sqlacodegen's defs

[nesnoj]

See no. 3.-6. in wiki.
@MGlauer Have you got any hints on this?

[MGlauer]

5. Ok, i took the time to read through the sqlacodegen code. By default, tailing s letters are considered as plurals and inflected (i.e. the s is cropped). This can be prevented by the parameter --noinflect (but this might affect other tables, too)

[MGlauer]

3. These types should not exist at all in the python code. they are translated (e.g. double precision -> Float). But this seems to be broken for Arrays. I opened a bug report

[MGlauer]

4. I guess there is no way to fix this other than renaming the column

[nesnoj]

Wow, tanks for your efforts! 👍

Concerning
3. We wait for an answer, they might fix it (or use your fork :)
4. openego/data_processing#102
5. sqlacodegen seems to use engine.singular_noun() from inflect (e.g. here) only to remove plural from last word of table name. As the *Bus-tables are the only ones who show this problem, I actually guess that no other tables will be affected. So for the next release I'd give it a try with the --noinflect option...

[Ludee]

metadata/meta_data is fixed!

[nesnoj]

Thx! I adjusted the wiki.

[gplssm]

As this is quite old and maybe outdated, I close. Please open a new issue if problems arise with upcoming releases.