You get the same experience inside VS Code with Copilot these days, as long as you select agent mode. Yesterday I even asked it to read documentation off a URL and it asked me permission to fetch the page, summarized it, and applied the API changes needed.
Not really. This is an example of something that Claude Code handles very easily and for Github Copilot, is not even an starter (because can't read SQLite files)
>Read the Sqlite file in this directory and create an UX that would visualize and manage the data. The application should be responsive (so it can be use on mobiles) and should have some graphs when appropiate.