[Bug]: Smart substitution and prepared statements need you to explicitly cast fields

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Current Behavior

Users have reported that when working with data types in SQL, JSON and number are impossible to insert without an explicit cast.
Similarly in APIs if an input has a number, the value is always sent as a string.

### Steps To Reproduce

1. Drag an Input widget
2. Create a postgres query to insert the input value into a table column with integer type
3. Enter a value and run the query
4. The query fails unless we cast it to an integer as
```
Insert into table1 (col1) values ({{Input1.text}} :: Integer)
```
The same can be reproduced for an API

### Environment

Production

### Version

Cloud