migrations/2020-12-17-030456_create_alias_views/up.sql

   1 -- Some view that act as aliases
   2 -- unfortunately necessary, since diesel doesn't have self joins
   3 -- or alias support yet
   4 CREATE VIEW user_alias_1 AS
   5 SELECT
   6     *
   7 FROM
   8     user_;
   9
  10 CREATE VIEW user_alias_2 AS
  11 SELECT
  12     *
  13 FROM
  14     user_;
  15
  16 CREATE VIEW comment_alias_1 AS
  17 SELECT
  18     *
  19 FROM
  20     comment;
  21