This post will show you how to create a Dynamics 365 TypeScript Web Resource and also how to use XrmDefinitelyTyped to have intellisense within Visual Studio !
A new feature is coming this year and is only available as preview for the moment. You are now able to connect your Dynamics 365 database. This SQL connection provides a read-only access to the CDS environment. You can see each column type of each entity and you can execute SQL request directly in the databases.