I’m trying to build a Diesel query that will make the search Postgres field defined as a varchar array similar to this SELECT value FROM table WHERE ANY VALUE IN array_column = 'Carol';
But this throws this error.

I’m trying to build a Diesel query that will make the search Postgres field defined as a varchar array similar to this SELECT value FROM table WHERE ANY VALUE IN array_column = 'Carol';
But this throws this error.

I have two tables, achievements, and user_achievements. The structure is similar to the following one:

Imagine that I have the following table:

I’m working on a Diesel project and want to streamline my migrations. Ideally, I’d like a single up.sql file that can handle both creating the table and adding new columns later. Is there a recommended approach to achieve this in Diesel, or do I need separate migrations for table creation and column additions?

I have a postgres database running on my computer and i have set the DATABASE_URL environment variable but when i try to setup my diesel ORM for my project i get this error

I have this sql migration query for the account entity: