PostgreSQL has features to generate SQL statements from queries. Let’s look at an example using YugabyteDB, which is Postgres-compatible and offers similar SQL views.
Once suspended, aws-heroes will not be able to comment or publish posts until their suspension is removed.
Once unsuspended, aws-heroes will be able to comment and publish posts again.
Once unpublished, all posts by aws-heroes will become hidden and only accessible to themselves.
If aws-heroes is not suspended, they can still re-publish their posts from their dashboard.
Once unpublished, this post will become invisible to the public and only accessible to Franck Pachot.
They can still re-publish the post if they are not suspended.
Thanks for keeping DEV Community safe. Here is what you can do to flag aws-heroes:
Unflagging aws-heroes will restore default visibility to their posts.