feat: Support PostgreSQL ARRAY constructor syntax

## Description
Add support for PostgreSQL ARRAY constructor and array operations.

## Example SQL
```sql
SELECT ARRAY[1, 2, 3];
SELECT * FROM users WHERE tags @> ARRAY['admin', 'moderator'];
SELECT ARRAY_AGG(name) FROM users;
```

## Priority
Medium - enhances PostgreSQL compatibility