The current handlers for path apps, subdomain apps (middleware) and web terminal need to be moved to the workspaceapps package, with their reliance on coderd.API and the database fully removed.

These handlers should only rely on the workspace connection code and the workspaceapps.TicketProvider interface from #6913.