title: Is there a way to select a subset of an array in Vapor/Fluent?
body: <p>I have a table in a PostgreSQL database used by a Vapor Swift app.  One of the columns in the table is an array of strings.</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE "Code" (
      id uuid PRIMARY KEY,
      name text NOT NULL,
      lines text[] NOT NULL
  );
  </code></pre>
  
  <p>I'd like to select some rows, pulling only the first four items from the array.  The raw SQL is this:</p>
  
  <pre><code>SELECT id, name, lines[1:4] FROM "Code"
  </code></pre>
  
  <p>Is there a way to specify the array subset via Vapor's Fluent syntax?  I would also be happy using a raw SQL query, that can then be decoded by the model (like <code>alsoDecode</code> with joins).</p>
  
  <p>This is the model, fwiw:</p>
  
  <pre class="lang-swift prettyprint-override"><code>struct Snippet: Codable, PostgreSQLUUIDModel {
      var id: UUID?
      var name: String
      var lines: [String]
  }
  </code></pre>
  
  <p>Thanks!</p>