I've worked out how to create a search form using content types and views, and I've worked out how to create forms inside modules.
What I really want, is a search form via forms functionality, but I want to add an extra form field in that search which utilises autocomplete using my own geographic database table (not in Drupal's tables).
I feel a bit trapped... I can't add a field in views, that isn't in the content type, yet I don't want to implement the search form in the module, as the views search form seems like the right way to do it.
I've got some street mapping data (X, Y coordinates for street names) in my own table (but it's in the Drupal database, with a different table prefix, and a different database user who can only access that table). [There are over 38,000 records].
1. Can I use Drupal 8's autocomplete functionality with my own database table?
2. Do I use PHP PDO, or does Drupal have something like that? (obviously I'm using my own database table as mentioned above)