[FEAT] Full path to source code location for `warning: dbt1065`

**Is your feature request related to a problem? Please describe.**

A warning like this should _also_ contain a link to the file where the warning is coming from:

```
========================================================= Errors and Warnings ==========================================================
warning: dbt1065: Detected columns with numeric type and unspecified precision/scale, this can lead to unintended rounding: ['amount']`
```

**Is your feature request related to a particular component of the dbt Fusion Engine**
- [x] CLI Features
- [ ] Adapter or Database Driver Features
- [ ] SQL Understanding Features
- [ ] VS Code extension

**Describe the solution you'd like**
Give the full path where the warning is coming from

**Describe alternatives you've considered**
We could leave as-is, but then how we suggest the user find it + fix it within their project?

**Additional context**

Here's an example model that will give this warning:

```sql
select 1 as order_id, cast(10.50 as numeric) as amount
```