export const loadRDBFields = async (attachment: Attachment, transaction: Transaction) => {
  const rs = await attachment.executeQuery(transaction, `
    SELECT 
      TRIM(rdb$field_name) AS rdb$field_name,
      CAST(rdb$validation_source AS VARCHAR(255)) AS rdb$validation_source,
      CAST(rdb$computed_source AS VARCHAR(255)) AS rdb$computed_source, 
      CAST(rdb$default_source AS VARCHAR(255)) AS rdb$default_source, 
      rdb$field_length,
      rdb$field_scale,
      rdb$field_type,
      rdb$field_sub_type,
      rdb$system_flag,
      rdb$null_flag,
      rdb$character_length,
      rdb$collation_id,
      rdb$character_set_id,
      rdb$field_precision
    FROM 
      rdb$fields
  `);
  try {
    return (await rs.fetchAsObject<IRDBField>()).reduce( (p, r) => (p[r.RDB$FIELD_NAME] = r, p), {} as IRDBFields);
  } finally {
    await rs.close();
  }
};