Things you will need:

1) MSSQL (or Sitecore) database file

2) JetBrains DataGrip

3) Docker

Steps: 

1) Extract MSSQL (or Sitecore) database file (most likely .zip)

If you are programmatically creating a node, and setting the alias is not working, make sure you have turned off the "Generate automatic URL alias" setting:

$node->path->pathauto = FALSE; $node->set('path', $st_alias); $node->save();

EntityTypeManager does not allow for filtering through moderation states, although it is in the works for Drupal 11: https://www.drupal.org/project/drupal/issues/3025164#comment-13221005. 

So if you don't want to patch core, here's how to alter your entity query for moderation states using hook_query_TAG_alter:

First add the hook funtion in your custom_module.module file: