Extract the 'name' field from the JSON object in the 'profile' column of the 'users' table.
CREATE TABLE users (profile JSON); INSERT INTO users (profile) VALUES ('{"name": "John Doe", "age": 30}');
```sql
SELECT profile->>'name' AS name FROM users;
```
```sql
SELECT profile->>'name' AS name FROM users;
```