I have tried out SSDT Database project in Visual Studio, and with the SQL Prompt solution from Red Gate. It seems that the intellisense only works for SQL keywords like SELECT, WHERE etc, it does not provide intellisense for table names, column names etc.
Is there a trick to get this working? (Tried in both VS2015 and VS2017).