Drop obsolete typing deps and overrides

Removes pypika-stubs dev dependency and related ignore_missing_imports overrides now that pypika ships py.typed; updates imports to use the modules that define them.